Quantitative Exercises and Valuation

Essay paper Finance
February 22, 2021
Original work NO RECYCLED work READ instructions detailed Due in 20 hours
February 22, 2021

Quantitative Exercises and Valuation

Part One: Application, Time Value of Money Calculations

Download the Week 1 quantitative exercises called FIN3030_W1_A3_Template.xlsx.

Required:

Complete the assignment using the formulas embedded in Microsoft Excel and/or a financial calculator. Include an Excel document that shows your calculations.

 

Part Two: Time Value of Money Problem

You would like to buy a new car in five years for cash. The price of the car today is $56,000 and you expect that the price will increase by 6% per year. You plan to save for this car starting today with a deposit in your savings account, which currently has a balance of $1,800 and earns 4% compounded annually.

You know that you will be receiving an inheritance of $3,500 three years from today, which you will deposit in your savings account for the car. If you make a deposit every month for the next five years beginning one month from today, how much will the deposit have to be in order for you to be able to pay cash for the car?

Required:

Complete the assignment using the formulas embedded in Excel and/or a financial calculator. Include an Excel document that shows your calculations.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.