Question: The negative arithmetic gradient series in Problem 3.44 is missing the value in year 4. Solve for this value on a spreadsheet. In doing so,

The negative arithmetic gradient series in Problem 3.44 is missing the value in year 4. Solve for this value on a spreadsheet. In doing so, display both the full amount of the missing payment and the extra amount over the expected amount of $-1600.

Problem 3.44

The future worth in year 8 for the cash flows shown is $20,000. At an interest rate of 10% per year, what is the value, x, of the cash flow in year 4?

2 3 5 6 1000 1200 1400 1800 2000 2200 2400

Step by Step Solution

★★★★★

3.50 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Payment in year 4 x 275589 Extra above arithmetic gradient value of 16... View full answer

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 Engineering Economy Questions!

An arithmetic gradient has cash flows of $1000 in year 4, $1200 in year 5, and amounts increasing by $200 per year through year 10. If you use the factor 200(PG,10%,n) to find PG in year 3, the value...

The equivalent annual worth of an increasing arithmetic gradient is $135,300. If the cash flow in year 1 is $35,000 and the gradient amount is $19,000, what is the value of n at an interest rate of...

Consider an EOY geometric gradient, which lasts for eight years, whose initial value at EOY one is $5,000 and f = 6% per year thereafter. Find the equivalent uniform gradient amount over, the same...

Create a spreadsheet to solve Example 6-11. What would the capital investment amount for pump SP240 have to be such that the firm would be indifferent as to which pump model is selected? The new...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

Using the PDF File, the Excel sheet needs to be completed. Master Budget Modeling Project for MyArmor, Inc. - 2017 Planning Year Project is Activated Save your project by following these directions -...

Answer the question in excel format. Excel formulas are below. 1. Solve for the unknown variables (identified with a ?) based on the information provided. Maturity / Future Value Interest Amount ? ?...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Evaluate the feasibility of the route

The average density of the moon is r = 3340 kg/m 3 . Find the minimum possible period T of a spacecraft orbiting the moon. The minimum period is when the orbit radius equals the objects radius, i.e.,...

11. Corporations are controlled by the . (LO1) a) employees c) common stockholders b) bondholders d) preferred stockholders

2. What are the determinants of social class?

Carla is a statistician with a bank. She has collected debt-to-equity mix data on mature (M) and young (Y) companies. The debt percentages vary from 20% to 80% in her sample. Carla has defined D M as...

A discrete variable X can take on integer values of 1 to 10. A sample of size 50 results in the following probability estimates: (a) Write out and graph the cumulative distribution. (b) Calculate the...

A discrete variable X can take on integer values of 1 to 5. A sample of size 100 results in the following probability estimates. (a) Use the following random numbers to estimate the probabilities for...

What is the primary / most common why can language lead to confusion in communication? Because speakers often use overly complex vocabulary. Because people deliberately try to deceive through...

Click here to read the eBook: Bond Yields Click here to read the eBook: Changes in Bond Values over Time BOND RETURNS Last year Janet purchased a $1,000 face value corporate bond with an 11% annual...

MMC Company manufactures a number of shoes products. Running shoes is one of the MMC's products that sells for Rm180 per unit. Total fixed cost related to running shoes are RM270, 000 per month and...