A company has $150,000 now. This money is saved at an interest rate i=8% for 5...

Transcribed Image Text:

A company has $150,000 now. This money is saved at an interest rate i=8% for 5 years. The question is about the equivalent value of this money after 5 years. Draw the timeline and show the sign convention Use the equations to calculate F. Please show all the steps clearly for grading. Write down (by hand) the Excel function you would use to calculate F and write a statement: "I applied the function in Excel and achieved the correct value." Now that you have F, use the equations to back-calculate P. Please show all the steps clearly for grading. Write down (by hand) the Excel function you would use to calculate P and write a statement: "I applied the function in Excel and achieved the correct value." A company has $150,000 now. This money is saved at an interest rate i=8% for 5 years. The question is about the equivalent value of this money after 5 years. Draw the timeline and show the sign convention Use the equations to calculate F. Please show all the steps clearly for grading. Write down (by hand) the Excel function you would use to calculate F and write a statement: "I applied the function in Excel and achieved the correct value." Now that you have F, use the equations to back-calculate P. Please show all the steps clearly for grading. Write down (by hand) the Excel function you would use to calculate P and write a statement: "I applied the function in Excel and achieved the correct value."