Question: You should have cells where you can enter different values for: Initial investment (P) Regular/repeated investments (PMT) Annual Interest Rate (APR) Compound frequency (n, #

You should have cells where you can enter different values for: Initial investment (P) Regular/repeated investments (PMT) Annual Interest Rate (APR) Compound frequency (n, # per year) The number of years for the investment (Y) You must have cells where you calculate: The interest rate per compound period. ( rate = APR/n ) The number of interest periods. (nper) The future value of the investment using the FV function. Use your spreadsheet to answer the following questions. Write the answers in a text box within your spreadsheet. What is the future value of a $1000 investment at 8% interest compounded annually for 5 years? What is the future value of a $5000 investment at 8% interest compounded monthly for 20 years? What is the future value of a $7500 investment at 6% interest compounded daily (assume 365 days/year) for 40 years? What is the future value of a $10,000 investment at 3% interest compounded quarterly for 50 years? Suppose that today I invest $1000 at 8% interest compounded monthly for 40 ye

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!

9-17a Tutorial 9 Practice Review Assignment Data File needed for the Review Assignments: Restaurant.xlsx Sylvia has some new figures for the business plan for Jerel's. She has received slightly...

The Coach Caf is a small neighborhood caf that serves vegetarian breakfasts and lunches. The owner of the caf, Keith Watson, started the caf with $50,000 of his own money. Now that hes up and...

give correct only678 16. Consider three stocks: Q. R and S. Beta STD (annual) Forecast for Nov 2008 Dividend Stock Price Q 0.45 35% $0.50 $45 R 1.45 10% 0 $75 S -0.20 40% $1.00 $20 33 2008, Andrew W....

Need a reflective essay (draft or 4-5 well thought out paragraphs. No need for APA unless you really want to, but I can do that myself) that addresses one of the following scenarios:...

Functional requirements: Your customer is a bank. They would like a program / application that does interest calculations with some console - based user interface. There are two calculations: The...

Why does the Short Run Aggregate Supply curve slope upwards while in the Long-Run Aggregate Supply is perfectly inelastic. 2. Assume we start in LR equilibrium. Suppose we see the consumer confidence...

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

Please, I need help with the calculations for the following 25 problems in the "final" tab of the workbook before 9pm CST. FINC 340 Quizzes 1 2 Derivatives can be strictly defined as Financial...

note - Statement of Financial Position (Opening Balance Sheet) at the beginining of the year Cash Flow report In completing the information in the 'CashMth' sheet, you will have to include any...

How would your answer to BE17- 20 change if year 1 income were equal to $ 100,000? Income (Loss) Year Before Tax $300,000 200,000 450,000) Tax Rate 40% 35% 35%

The comparative statements of Income and Financial position are given below: \ table [ [ , 2 0 2 3 ( Rs . ) , 2 0 2 4 ( R s . )

7. Dave's Manufacturing reported the following income statement for 2019: Sales $85,000,000 Depreciation Raw materials Wages Gen/Admin $48,000,000 19,000,000 3,500,000 6,000,000 Total Operating...