Question

Present Values: Please provide the calculations in MS Excel for the present value of an $7,000...

Present Values:

Please provide the calculations in MS Excel for the present value of an $7,000 goal in 7 years at 7% discounted on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

Future Values:

Please provide the calculations in MS Excel for a future value of an $7,000 investment today in 7 years at 7% compounded on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

Present Value of an Annuity:

Please provide the calculations in MS Excel for the present value of an annuity amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the present value of an annuity due amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Future Value of an Annuity:

Please provide the calculations in MS Excel for the future value of an annuity amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the future value of an annuity due amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Interest Rate Calculation:

Calculate the interest rate to the nearest basis point (0.0001) for a $40,000 investment with an $70,000 financial goal for 7 years. No payments will be made during the 7 years.

Number of Periods Calculation:

Calculate the number of years needed to earn $70,000 with a $50,000 initial investment earning an 7% annual interest rate. Please round to the fourth decimal place. No payments will be made during the 7 years.

APY or EAR:

To the nearest basis point, calculate the yield of 17% on a semi-annual, quarterly, monthly, and daily basis utilizing equation 4.14 on page 167.   Show all calculations in MS Excel to the fourth decimal place.

Loan Amortizations:

Please construct an annual loan amortization table for a loan of $40,000 for 4 years at 7%. Please utilize figure 4.11 on page 172. You will have to find the payment first before constructing the amortization table. Make sure to provide the number of periods, the beginning balance, the payment, the interest dollar amount, the principal dollar amount, and the ending balance for each of the five years.

Homework Answers

Answer #1

As per rules I will answer the first 4 sub parts of this question.

FV $7,000
Rate 7%
N 7 years
Discounting PV
1.Annual ($4,359.25)
2. Semiannual ($4,324.47)
3. Quarterly ($4,306.60)
4. Monthly ($4,294.49)
5. Daily ($4,288.59)

The computations are as per the excel below

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please show work, thank you in advance :) What is the present value of a semi-annual...
Please show work, thank you in advance :) What is the present value of a semi-annual ordinary annuity payment of $7,000 made for 12 years with a required annual return of 5%? $ 65,145 $128,325 $125,195 (correct) $ 62,043 You deposit $10,000 in a bank and plan to keep it there for five years. The bank pays 8% annual interest compounded continuously. Calculate the future value at the end of five years. $14,693 $15,000 $14,918 (correct) $14,500 What is the...
3. How much will the future value of an annual annuity of $35 be worth after...
3. How much will the future value of an annual annuity of $35 be worth after 13 years at 3% interest if interest is compounded annually, semi-annually, quarterly, monthly and daily? Fill in the table below with your answers. Hint: if the compounding is annually, there is one $35 payment in a year, if the compounding is semi-annually, there are two $17.50 payments in a year, etc.. Annual Semi-annual Quarterly Monthly Daily
1. A 6?-month ?$9000 Treasury bill with discount rate 8.671?% was sold in 2009. Find a....
1. A 6?-month ?$9000 Treasury bill with discount rate 8.671?% was sold in 2009. Find a. the price of the? T-bill, and b. the actual interest rate paid by the Treasury. a. The price of the? T-bill is ?$ ?(Round to the nearest dollar as? needed.) 2. Suppose that ?$30,000 is invested at 7?% interest. Find the amount of money in the account after 8 years if the interest is compounded annually. If interest is compounded? annually, what is the...
Complete each of the following TVOM calculations using Excel. The assignment MUST be completed on an...
Complete each of the following TVOM calculations using Excel. The assignment MUST be completed on an excel spreadsheet and submitted through blackboard. There are 10 calculations to answer. The TVOM functions are under the Fx button in Excel. The Fx Function is located just above the actual number section of your spreadsheet, right above the C or D column in most blank spreadsheets. Click on the Fx button and search for the specific function (present value, future value, Rate, payment,...
Find the future value of an ordinary annuity of $7,000 paid quarterly for 4 years, if...
Find the future value of an ordinary annuity of $7,000 paid quarterly for 4 years, if the interest rate is 8%, compounded quarterly. (Round your answer to the nearest cent.)
Calculate the present value of $7,000 received four years from today if your investments pay (Do...
Calculate the present value of $7,000 received four years from today if your investments pay (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Present Value a. 6 percent compounded annually b. 8 percent compounded annually c. 10 percent compounded annually d. 10 percent compounded semiannually e. 10 percent compounded quarterly
1. Calculate the present value of an annuity stream that pays $20,000 every year for 5...
1. Calculate the present value of an annuity stream that pays $20,000 every year for 5 years on the last day of each year if your investment pays 20% compounded quarterly? 2. Calculate the future value of $20,000 invested today for 6 years if your investment pays 4% compounded annually 3. Calculate the future value of an annuity stream that pays $6,000 every year for 5 years on the last day of each year if your investment pays 10% compounded...
Calculate the future value in four years of $7,000 received today if your investments pay (Do...
Calculate the future value in four years of $7,000 received today if your investments pay (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Future Value a. 5 percent compounded annually $ b. 7 percent compounded annually c. 9 percent compounded annually d. 9 percent compounded semiannually e. 9 percent compounded quarterly
What is the present value of the following annuity? $1,070 every half year at the beginning...
What is the present value of the following annuity? $1,070 every half year at the beginning of the period for the next 14 years, discounted back to the present at 3.13 percent per year, compounded semiannually. You plan to buy a house in 14 years. You want to save money for a down payment on the new house. You are able to place $348 every month at the end of the month into a savings account at an annual rate...
Present value of an ordinary annuity. Fill in the missing present values in the following table...
Present value of an ordinary annuity. Fill in the missing present values in the following table for an ordinary​ annuity: LOADING... . Number of Payments or Years Annual Interest Rate Future Value Annuity Present Value 9 7​% 0     ​$235.49 ​$nothing  ​(Round to the nearest​ cent.)
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT