Question: i need help with this assignment please Please do this in Excel. Only Excel sheets will be accepted. All answers to 2 decimal place. You

i need help with this assignment please
i need help with this assignment please Please do this in Excel.

Please do this in Excel. Only Excel sheets will be accepted. All answers to 2 decimal place. You can write in the text for the 1" question in the spreadsheet. If you want to use Excel functions that is fine, as long as I can easily follow your work work. 1) List the equation that shows the relationship between Present Value (PV) and Future Value 2) $1,000 today will be worth how much in 10 years if it earns 5% annually? 3) $1,000 today will be worth how much in 10 years if it earns 10% annually? 4) $1,000 today will be worth how much in 10 years if it earns 12% annually? 5) If you were to receive $10,000 in 7 years, and you think the appropriate discount rate is 6%, what is it worth to you today? 6) If you were to receive $10,000 in 7 years, and you think the appropriate discount rate is 9%, what is it worth to you today? 7) If you borrow $1,500 today and promise to repay $2,114.50 in 5 years, what is the interest rate you are paying. 8) How long will it take for your money to triple if you earn 5%? 9) How long will it take for your money to triple if you earn 9%? 10) How long will it take for your money to triple if you earn 15%? Bonus Question You will earn 12% a year for 15 years on $2,000, but it will be compounded at different rates. How much will you have if it is compounded A) Annually B) Quarterly C) Monthly D) Daily Hint: If it is compounded monthly, that is the same as earning 1% a month (ie. 129/12). But you have to adjust the 15 years to months also

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!