In-Class Spreadsheet- Week 4- Time Value of Money Calculations

.xlsx
School
Colorado Christian **We aren't endorsed by this school
Course
FINANCE 311
Subject
Finance
Date
Oct 29, 2023
Pages
8
Uploaded by PresidentDiscoveryDove30 on coursehero.com
In-Class Spreadsheet 4- Time Value of Money Calculations Complete the shaded areas in the next tab be sure to read the instructions carefully- some ask you to answer manually-using the math fo Make sure that all green sections are completed We will be attempting to complete all the calculations in class Let me know if you have any questions! Craig 303-880-5806 Save the completed spreadsheet using the naming convention Lastname Firstname In Class S [email protected]
ormulas others will ask you to use the Excel tools Spreadsheet 4 --and submit it with your journal in the link provided in Birghtspace
Time Value of Money Calculations Manually Calculate the following- Use the formulas- Not the Excel Tools, Show your ans Use the same discount rate of 10% for each computation The present value of $ 10,000 received 10 years from no The future value of $ 125,000.00 7 years from no The present value of $1,500,000 received annually- that continues forever The present value of $80,000 received monthly- that continues forever The future value of an annuity of $ 45,000 per year for 5 years The present value of an annuity of 12000 per month for 70 months Using the Excel functions/tools and same discount rate above, calculate the following- The future value of $ 500 70 years from no The future value of $ 127,500 24 months from The present value of $ 1,100,000 received 30 years from no The present value of $ 5,000 received 32 months from The future value of an annuity of $ 500 per month for 5 years The future value of an annuity due of $ 20,000 per quarter for 12 years The present value of an annuity due of $ 500 per month for 40 years The future value of an annuity of $ 2,000 per month for 15 years The present value of an annuity of $ 2,000 per month for 15 years
Page1of 8
Uploaded by PresidentDiscoveryDove30 on coursehero.com