Question: The second photo is only a sample. Could you PLEASE compute the problem similar to this format. Thank you. Please notice that all work must

 The second photo is only a sample. Could you PLEASE compute
the problem similar to this format. Thank you. Please notice that all
The second photo is only a sample. Could you PLEASE compute the problem similar to this format. Thank you.

Please notice that all work must be shown in a professione! way with attention to detail No credit will be given for incomplete or disorderly work Please use a cover letter stating your name, course number, date due, and homework number Unstapled homework will not be collected as this is part of the assignment All work must be individual with emphasis on numerical accurocy as shown in class and submit your neat spreadsheet Exercise One: Compute the Future Value of 100,000 USD (U.S. Dollars), 10 years from today, if the interest rate is 8.25%, assuming: (a) simple interest, (b) daily compounding, (c) verify your answer for part (b) by using the FV function as shown in class today, (d) continuous Exercise Two: Compute the Future Value of 5,000 USD (U.S. Dollars), 20 years from today, if the interest rate is 6.25%, assuming: (a) simple interest, (b) daily compounding, (c) verify your answer for part (b) by using the FV function as shown in class today, (d) continuous compounding. Exercise Three: Compute the Present Value of 30,000 USD (U.S. Dollars), received 15 years from today, if the interest rate is 7.45%, assuming: (a) simple interest, (b) daily compounding, (c) verify your answer for part (b) by using the PV function as shown in class today, (d) continuous compounding. Exercise Four: Compute the Present Value of 25,000,000 USD (U.S. Dollars), received 35 years from today, if the interest rate is 4.25%, assuming: (a) simple interest, (b) daily compounding, (c) verify your answer for part (b) by using the PV function as shown in class today, (d) continuous compounding. Extra Credit: You deposit $75,000 in an interest bearing account, after 12 years, the balance on the account is $165,000. Using the equations discussed in class, find the average interest rate assuming: (a) semiannual compounding, and (b) daily compounding. Time Annual Interest Rate Payment Frequency Periodic interest rate Total no. of Payments 40 i)An 1.46691123752586 0.681704506 33.06966175 119050.7323 PV Annuity PV Function 119050.7823 Time 1.001875 1.09408208187414 130251 3278 F v monthly compounding FV Function1302513278 Time Annual Interest Rate Payment FrequencyPeriodic interest rate Total no. of Payments 16 0.01187S 64 101187S 2.12872436104246 0.469764906 0.530235094 4.65137631 PV Annuity Payment Time Annua 0.002708333 48 1+i 1.002708 1.13862828090628 127103. 29968 EV monthly compounding FV Function 3 Payment Time Annual Interest Rate Payment Frequency Periodic interest rate Total no. of 0.003125 1.003125 3.07481839521478 0.674777541 539822,0327 PV Annuity PV Function 539822.0327 Time 1460 1.09417123965310 590657.7427 FV monthly compoundin FV Function 590657.7427

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!