please do show formulas. thanks

you buy this investment based on your answer to part, and why? (Compare expected return to required return). 6. Consider the present value of the following different investments. Recall the nominal rate 8.00% Present Value a. What is the present value of $1,000,000, due 25 years from now? b. What is the present value of a $40,000 ordinary annuity for 25 years? (Hint: $40,000 is the payment) c. What is the present value of a $40,000 perpetuity, if the first payment is 1 year from now? d. What is the present value of a $40,000 perpetuity, if the first payment is now? 7. You take out a loan today and will make equal annual payments for the next 3 years, starting in 1 year Amount borrowed a. What is the value of the annual payment if the nominal interest on the loan is: 50,000 6.00% Payment Payment Interest Principal b. Show the amortization of the loan in the table set up below: Year Beg Balance 1 2 3 TOTAL Sheet1 Sheet2 Sheet3 you buy this investment based on your answer to part, and why? (Compare expected return to required return). 6. Consider the present value of the following different investments. Recall the nominal rate 8.00% Present Value a. What is the present value of $1,000,000, due 25 years from now? b. What is the present value of a $40,000 ordinary annuity for 25 years? (Hint: $40,000 is the payment) c. What is the present value of a $40,000 perpetuity, if the first payment is 1 year from now? d. What is the present value of a $40,000 perpetuity, if the first payment is now? 7. You take out a loan today and will make equal annual payments for the next 3 years, starting in 1 year Amount borrowed a. What is the value of the annual payment if the nominal interest on the loan is: 50,000 6.00% Payment Payment Interest Principal b. Show the amortization of the loan in the table set up below: Year Beg Balance 1 2 3 TOTAL Sheet1 Sheet2 Sheet3 7. You take out a loan today and will make a payments for the west 3 years, starting in 1 year Amount brewed 50.000 What is the value of the payment if the che 6. Payment Show the state of the faith the below Year Beg Balance Payment Interest Princinal Ending Balance TOTAL Whe MacBook Pro INPUT DATA Answers MUST be derived wing cell references using om OR E function Just in your answer delved in your call NOT You MUST FORMAT ALL of winters PERCENTAGES DECIMALS V MUST FORMAT ALL you do. CURRENCY DECIMALS Y MUST of the For questions 1. refer to the input data box highlighted in INPUT DATA Answers MUST be derived using call references in om OR E function Justing in your answer derved wing your call NOT in any You MUST FORMAT ALL of winters PERCENTAGES DECIMALS V MUST FORMAT ALL of your des CURRENCY DECIMALE V MUST of the Ry For questions 1 - 4 refer to the input data box highlighted in