Question

Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero at MARR = 7%. The study period needs to be exactly 18 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

Answer #1

Assume the initial cash out flow in this case i assume 50000 as cash out flow and divide this initial outflow by 18 Years to get each year cash inflow Present value.

From 1st years onward increase the cash inflow by (1+7%) upto 18 years

For cash inflow for nth years = (50000/18)*(1+7%)^n

Year | cash flow |

0 | -50000.00 |

1 | 2972.22 |

2 | 3180.28 |

3 | 3402.90 |

4 | 3641.10 |

5 | 3895.98 |

6 | 4168.70 |

7 | 4460.50 |

8 | 4772.74 |

9 | 5106.83 |

10 | 5464.31 |

11 | 5846.81 |

12 | 6256.09 |

13 | 6694.01 |

14 | 7162.59 |

15 | 7663.98 |

16 | 8200.45 |

17 | 8774.49 |

18 | 9388.70 |

Using Microsoft Excel, create an investment cash-flow diagram
that will have a present worth of zero at MARR = 7%. The study
period needs to be exactly 18 years and each year should have at
least one unique cash-flow that is different from the cash-flows
over the other years. Your answer should contain a table showing
the cash-flows for each year and a graphical representation of the
cash-flows (cash-flow diagram).

Tempura Inc. is considering two projects. Project A
requires an investment of $50,000. Estimated annual receipts for 20
years are $20,000; estimated annual costs are $12,500. An
alternative project, B, required an investment of $75,000, has
annual receipts for 20 years of $28,000, and has annual costs of
$18,000. Assume both projects have a zero salvage value and that
MARR is 12%/year.
Please show cash flow diagram and please don't use excel
functions. Thank you!
a. What is the present...

What is the Present Worth (Pw) in Year 0 of $12,000 cash flow in
Year 1 which then increases by $500 each year for Years 2 - 6. Use
i=8%/yr

A stream of payments over a 5-year period have a present worth
of $100,000. Payments in years 1, 4 and 5 are $15,000, $30,000, and
$35,000, respectively. The value in years 2 and 3 must be
determined. Year 3 is twice year 2. What are the values of year 2
and year 3’s payments? No Interest. PLEASE INCLUDE A CASH FLOW
DIAGRAM or I will not rate. Thank you!

Uneven Cash Flow Stream
Find the present values of the following cash flow streams. The
appropriate interest rate is 11%. (Hint: It is fairly easy
to work this problem dealing with the individual cash flows.
However, if you have a financial calculator, read the section of
the manual that describes how to enter cash flows such as the ones
in this problem. This will take a little time, but the investment
will pay huge dividends throughout the course. Note that,...

Uneven Cash Flow Stream
Find the present values of the following cash flow streams. The
appropriate interest rate is 6%. (Hint: It is fairly easy
to work this problem dealing with the individual cash flows.
However, if you have a financial calculator, read the section of
the manual that describes how to enter cash flows such as the ones
in this problem. This will take a little time, but the investment
will pay huge dividends throughout the course. Note that,...

please Clearly present the cash flow diagram(s),
equivalency model(s),
assumptions made and detailed calculations. ( dont use exel
tables)
A manufacturing firm purchases some machinery in
January for $1,000,000. The machinery has an estimated life of 5
years, with an estimated salvage value of $200,000. The use of this
machinery should generate $400,000 before-tax profit each year over
its 5-year useful life. Calculate the before-tax and after-tax
rates of return if the company uses declining balance at 150% to
depreciate...

Find the present values of the following cash flow streams. The
appropriate interest rate is 8%. (Hint: It is fairly easy
to work this problem dealing with the individual cash flows.
However, if you have a financial calculator, read the section of
the manual that describes how to enter cash flows such as the ones
in this problem. This will take a little time, but the investment
will pay huge dividends throughout the course. Note that, when
working with the...

Find the present values of the following cash flow streams. The
appropriate interest rate is 8%. (Hint: It is fairly easy
to work this problem dealing with the individual cash flows.
However, if you have a financial calculator, read the section of
the manual that describes how to enter cash flows such as the ones
in this problem. This will take a little time, but the investment
will pay huge dividends throughout the course. Note that, when
working with the...

Find the present
values of the following cash flow streams. The appropriate interest
rate is 7%. (Hint: It is fairly easy to work this problem
dealing with the individual cash flows. However, if you have a
financial calculator, read the section of the manual that describes
how to enter cash flows such as the ones in this problem. This will
take a little time, but the investment will pay huge dividends
throughout the course. Note that, when working with the...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 27 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago