Instructions Using Financial Formulas in Excel, answer the following problems in a single Excel worksheet Round to the nearest dollar You must turn in an Excel document Please include the formula you enter into excel spreadsheet, and answer Thank you ONLY QUESTIONS 5,6,7, 8 What is the balance in an account at the end of 5 years if $1,500 is deposited today and the account earns 3 5 interest compounded annually $1,781 53 How much interest is earned in an account by the end of 10 years if $50,000 is deposited at the beginning of year 1 and interest is 5 per year, compounded semi annually ($1,309,163 70) If you wish to accumulate $60,000 in 4 years, how much must you deposit today in an account that pays annual interest rate of 8 , with quarterly compounding of interest ($43,706 75) If you deposit $5,000 at the end of each year for 10 years in an account that pays an annual interest rate of 2 , what will your account be worth at the end of 5 years ($26,020 20) You decide that you need $63,000 in 7 years to make a down payment on a house You plan to make annual fixed deposits to achieve your goal If the interest rate is 1 5 , how much should be deposited each time Hint use the Financial Function PMT to solve for the payment, and PV will be zero You owe $20,000 to your parents You promise to make 8 annual payments of $3,000 to settle your debt What interest rate are your parents charging (estimated up to 2 decimal places), if you make the 8 annual payments beginning one year from now Hint use the Financial Function RATE Note if you need help use the Help on this function feature This help will include an example for you to follow You are offered an investment that will pay $12,000 per year for 15 years, beginning one year from now If you feel that the appropriate discount rate is 1 2 , what is the investment worth to you today Your grandparents offered you some money via the following options Assuming an annual interest rate of 12 , which option should you choose Show your work Receive $10,000 immediately Receive $1,000 at the end of each six months for seven years This results in payments totaling $14,000 You will receive the first check in six months Receive $500 at the end of each year for four years, and then $10,000 at the end of the fifth year This results in payments totaling $12,000

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 10, 2024

Instructions: Using Financial Formulas in Excel, answer the following problems in a single Excel worksheet. Round to the nearest dollar. You must turn in an

Instructions: Using Financial Formulas in Excel, answer the following problems in a single Excel worksheet. Round to the nearest dollar. You must turn in an Excel document!

Please include the formula you enter into excel spreadsheet, and answer. Thank you! ONLY QUESTIONS 5,6,7,& 8!

What is the balance in an account at the end of 5 years if $1,500 is deposited today and the account earns 3.5% interest compounded annually?

$1,781.53

How much interest is earned in an account by the end of 10 years if $50,000 is deposited at the beginning of year 1 and interest is 5% per year, compounded semi-annually?

($1,309,163.70)

If you wish to accumulate $60,000 in 4 years, how much must you deposit today in an account that pays annual interest rate of 8%, with quarterly compounding of interest?

($43,706.75)

If you deposit $5,000 at the end of each year for 10 years in an account that pays an annual interest rate of 2%, what will your account be worth at the end of 5 years?

($26,020.20)

You decide that you need $63,000 in 7 years to make a down payment on a house. You plan to make annual fixed deposits to achieve your goal. If the interest rate is 1.5%, how much should be deposited each time? Hint use the Financial Function ?PMT? to solve for the payment, and PV will be zero.

You owe $20,000 to your parents. You promise to make 8 annual payments of $3,000 to settle your debt. What interest rate are your parents charging (estimated up to 2 decimal places), if you make the 8 annual payments beginning one year from now? Hint use the Financial Function ?RATE?. Note if you need help use the ?Help on this function? feature. This help will include an example for you to follow.

You are offered an investment that will pay $12,000 per year for 15 years, beginning one year from now. If you feel that the appropriate discount rate is 1.2%, what is the investment worth to you today?

Your grandparents offered you some money via the following options. Assuming an annual interest rate of 12%, which option should you choose? Show your work.

Receive $10,000 immediately
Receive $1,000 at the end of each six months for seven years. This results in payments totaling $14,000. You will receive the first check in six months.
Receive $500 at the end of each year for four years, and then $10,000 at the end of the fifth year. This results in payments totaling $12,000.