You place $100 into a fund at the end of each month for 3 years. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 2 ? 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. Note: there may be slight discrepancies between the answers in parts (a) and (b) due to rounding. [8] 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 2 ? 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. Note: there may be slight discrepancies between the answers in parts (a) and (b) due to rounding. [8]
Expert Answer:
Answer rating: 100% (QA)
Part a Calculation with Spreadsheet Program Calculation for each month Month Depo... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-1337395250
15th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Suppose you buy Bond A at time=0. It is a 2-year, risk-free bond with coupon rate of 7% that compounds annually, and it has a face value of $1,000. (3 points) a) At time = 0, suppose you buy Bond A...
-
The Bolognese Corporation is in the process of setting price standards for its direct materials. Polymer clay is used in one product. The polymer clay is purchased for $14 per kilogram. The Bolognese...
-
Ricardo's offers customer's two kinds of pizza crust, Roman (R) and Neapolitan (N). All pizzas have cheese but not all pizzas have tomato sauce. Roman pizzas can have tomato sauce or they can be...
-
Should we resign ourselves to the continued growth of the gig economy or fight for the right to full-time labor with benefits to and protections for workers? In Ghost Work: How to Stop Silicon Valley...
-
Hoosier Manufacturing operates a production shop that is designed to have the lowest unit production cost at an output rate of 100 units per hour. In the month of July, the company operated the...
-
What type of capacity planning tools would you use to ensure that your IT workplace is operating at optimal efficiency?
-
According to the assigned case study, Lawn King must develop an S&OP plan that considers the costs of inventory, overtime, hiring, and layoff (beware of stock outs). If the plan results in back...
-
Linearize the following nonlinear ordinary differential equation with input u and output y. =y-y tu Y(s) Find a transfer function at the operating point y* = 1. Notice that the autonomous (u = 0)...
-
Rolex Company reports the following information. Current Year Prior Year Sales Cost of goods sold $ 220,000 132,000 $ 180,000 135,000 1. Compute the gross profit ratio for each of the two years...
-
Assume that in Case 1 the other items in the current assets section are as follows: cash $ 3 , 0 7 0 , receivables ( net ) $ 1 0 , 1 8 0 , raw materials $ 9 4 0 , and prepaid expenses $ 2 3 0 ....
-
The 2024 income statement of Adrian Express reports sales of $15,015,000, cost of goods sold of $8,863,500, and net income of $1,570,000. Balance sheet information is provided in the following table....
-
lion corporation has provided its contribution former income statement for June. sales 1 2 1 0 0 0 : variable expense 6 0 5 0 0 : contribution margin 6 0 5 0 0 : fixed expense 4 3 7 0 0 : net...
-
2. On December 31, 2020, the total assets of Allen, Inc. were $91,000, and liabilities were $48,000. Allen, Inc. began business January 1, 2016, and had an average net income of $16,000 per year....
-
Gant Co. purchased a machine on July 1, 2001, for $500,000. The machine has an estimated useful life of five years and a salvage value of $100,000. The machine is being depreciated from the date of...
-
The outer loop controls the number of students. Note that the inner loop of this program is always executed exactly three times, once for each day of the long weekend. Modify the code so that the...
-
The Warren Watch Company sells watches for $26, fixed costs are $155,000, and variable costs are $13 per watch. a. What is the firms gain or loss at sales of 9,000 watches? At 15,000 watches? b. What...
-
Misuraca Enterprises current stock price is $45 per share. Call options for this stock exist that permit the holder to purchase one share at an exercise price of $50.These options will expire at the...
-
Arlington Corporations financial statements (dollars and shares are in millions) are provided here. a. What was net operating working capital for 2017 and 2018? Assume that all cash is excess cash;...
-
What is thermodynamics?
-
An astronaut weighs \(800 \mathrm{~N}\) on the earth's surface where the acceleration of gravity is \(g=9.83 \mathrm{~m} / \mathrm{s}^{2}\). The mass and the radius of the moon are \(7.4 \times...
-
Explain the scope and limitations of thermodynamics.
Study smarter with the SolutionInn App