Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following 5-years investment table of Agus's cash flow with required return rate j=11% (RRR). Discounted is a discount factor based on RRR. Contribution

image text in transcribed

Consider the following 5-years investment table of Agus's cash flow with required return rate j=11% (RRR). Discounted is a discount factor based on RRR. Contribution is amount of money that Agus paid to start the business (investment). Whereas, return is amount of money that Agus received from the investment. Furthermore, PV Contrib is present value of Contribution based on RRR, then Net Cash Flow is Return minus Contribution. Moreover, Discounted Cash Flow is present value of Net Cash Flow based on RRR. Finally, NPV at year "4" is NPV of investment from now (t=0) until year "Y". If t=5 then the investment has settled or matured. Year Discounted Contribution Return PV Contrib Net Cash Flow Discounted Cash Flow NPV at yeart 1 10000 10000 -10000 - 10000 10000 1 0.9009009 3000 3000 2702.7027 0 -10000 2 0.81162243 1000 5000 811.62243 4000 3246.489733 -6753.51027 3 0.73119138 1000 6000 731.19138 5000 3655.956907 -3097.55336 4 0.65873097 1000 6000 658.73097 5000 3293.654871 196.1015102 5 0.59345133 1000 4000 593.45133 3000 1780.353984 1976.455494 Figure 1: Agus's Cash Flow under RRR=11% 0 (a). Calculate the Profitability Index of this investment under required return rate. (b). Find the discounted payback period over this investment under required return rate. (c). From the cash flow of contribution and return, Agus knew that this investment will yield an internal return rate (IRR = 0.172894062). Based on modified internal return rate (MIRR), what can you conclude from Agus's investment? Please give a comment to analyze this investment. Show your work to produce the equated value of modified NPV under MIRR method. Hint: You have to look for theory of Profitability Index, Discounted Payback Period, and MIRR. For Profitability Index (PI) = NPV/I and it's computed under RRR (1). For Discounted Payback Period, find the minimum k for which NPV until k-year is positive under RRR (). For MIRR method, you must show that present value of Return under IRR is greater than the present value of Contribution under RRR. State your comment and conclusion from your work especially in MIRR

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Services Sales Handbook A Professionals Guide To Becoming A Top Producer

Authors: Clifton T. Warren

1st Edition

1631574930, 978-1631574931

More Books

Students also viewed these Finance questions

Question

explain what is meant by experiential learning

Answered: 1 week ago

Question

identify the main ways in which you learn

Answered: 1 week ago