Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 3 (16 marks) You place $100 into a fund at the end of each month for 3 years. The annual nominal interest rate is

image text in transcribed
Question 3 (16 marks) You place $100 into a fund at the end of each month for 3 years. The annual nominal interest rate is 2% in the first year, 2.5% in the second year, and 3% in the third year. (a) Using a spreadsheet programme (Excel, WPS or the likes), find the interest and accumulated amount at each compounding period over the three years. Display your results in a table as the one shown below: Month Deposit Interest Accumulated Amount 1 100 100 2 100 ? ? I 1 You do not need to include screenshots of your answer here. Submit your spreadsheet. [8] (b) Refer to Example 2.4 of Chapter 2. Use a similar process to find the accumulated value of the fund at the end of the third year. Round your answer to the nearest cent. [8] Note: there may be slight discrepancies between the answers in parts (a) and (b) due to rounding

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Consumer Credit And The American Economy

Authors: Thomas A. Durkin, Gregory Elliehausen, Michael E. Staten, Todd J. Zywicki

1st Edition

ISBN: 0195169921, 978-0195169928

More Books

Students also viewed these Finance questions

Question

what media type is used by 1 0 GBASE - SR

Answered: 1 week ago