Question: Each column is a separate equation - it is complete. For Column 1 - what is the present value if the interest rate is 7%,

Each column is a separate equation - it is complete.

For Column 1 - what is the present value if the interest rate is 7%, time period = 6, and the future value is $15,451

Columnn 2 - what is the interest rate if the present value is $242, time period = 2, and the future value is $303

Column 3 - what is the number of years (time period) if present value is $625, rate of 6% and future value is $1330

need to show all calculations. question is regarding time Value of Money and need to enter in the blank values:

2.Complete the table below (You may use Excel functions, a calculator or your own formulas)
column 1 column 2 column 3
Present value ____________________ $ 242 $ 625
Interest rate 7.0% ____________________ 6.0%
Years 6 2 ____________________
Future value $ 15,451 $ 303 $ 1,330

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!

Q:

i do not understand this can someone please help me with this? Time Value of Money, Opportunity Cost, and Income Taxes Worksheet FP/100 Version 1 1 Time Value of Money, Opportunity Cost, and Income...

Q:

Sheet 2 (Unit 2) is where I have started my work. Ch. 4 Problem 2a-c Calculating Future Values : Compute the future value of $3,200 compounded annually for a. 10 years at 6 percent b. 10 years at 8...

Q:

Use comparable to start to develop a plan for a current project using data from previous projects. As we start to develop this proforma to evaluate alternative cost proposals, we are going to build...

Q:

The goal of this project is to explore the topic of the time value of money. The project requires you to work in Excel with the provided spreadsheet. Be sure to fill in the yellow boxes in the Excel...

Q:

please with full explanations. Thanks Ok thanks. that's the available information I have on the question and I have tried for 2days and I can't figure my way out. that's the reason I turn to an...

Q:

Ctrl MBA 6400: Case Study #1 Revised: 2020-Mar-20 Short-term investment returns: money market instruments. You are an analyst in the insurance industry and are tasked with ensuring that there is a...

Q:

AaBbCcDdee List Paragraph 31 Time Value of Money, Opportunity Cost, and Income Taxes Worksheet Scenario 1: Time Value of Money Cash Management Products Use this Bankrate's Simple Savings calculator...

Q:

Company A To: Glenda Weber, Accounting Director Shawn Grayson, Finance Director From: Robert Fleming, Treasury Director Date: January 5, Year 1 Subject: Purchase of Bonds from Company B Glenda/Shawn,...

Q:

3:27 Il 21% TIME VALUE OF MONEY PROBLEMS 1. Fill in the missing amount in each independent column: A, B, C (TVM of a Single Sum): Present Value Years Interest Rate Future Value A (Annual) $15,000 6...

Q:

Question 13 pts Present value = $100; Interest rate = 5%; Number of years = 11 (assume annual compounding). What is the future value? Group of answer choices 155.00 223.13 171.03 55.00 Flag question:...

Q:

XYZ Pty Ltd operates a small business with annual turnover estimated at $1.4 million. XYZ Pty Ltd accounts for and reports GST on a cash basis quarterly. XYZ pays quarterly PAYG income tax instalment...

Q:

In Exercises 26, state whether each standardized test statistic z allows you to reject the null hypothesis. Explain your reasoning (a) z = 1.98 (b) z = -1.89 (c) z = 1.65 (d) z = -1.99 -3 210 /2 3...

Q:

1 . Roths Accounts: a . Are Roth Contributions tax deductible? _ _ _ _ _ _ _ b . Assuming a taxpayer meets the requirements for a normal distribution from a Roth account, will the distribution from a...

Q:

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...