Plot future worth as function of MARR

Reference no: EM132002418

Julian Stewart invested $280,000 in a limited partnership to drill for natural gas. The investment yielded annual returns of $45,000 the 1st year, followed by $10,000 increases until the 6th year, at which time an additional $180,000 had to be invested for deeper drilling. Following the 2nd drilling, the annual returns decreased by $10,000 per year, from $85,000 to $5,000. Using Excel, the IRR = 15.28%.

a) Plot future worth as a function of MARR

b) Plot future worth as a function of MARR (MARR ranges from -50% to +50% increment by 5%)

c) Determine the MARR that maximizes FW

(Use only Excel to solve and show your work in Excel)

Reference no: EM132002418

Questions Cloud

Discuss the pros and cons for the design of sdlc : Make recommendations on the requirements for the feasibility study and discuss the pros and cons for the design of SDLC with a recommendation.

Can raise funds for capital investments : What are a few ways a firm, can raise funds for capital investments?

Assess senior management responsibility for the failure : Assess senior management responsibility for the failure in question. Specify what the senior management could have done differently to avoid the failure.

Application designed to handle 500ip-based sessions : A bank is experiencing a DOS attack against an application designed to handle 500IP-based sessions.

Plot future worth as function of MARR : Determine the MARR that maximizes FW. Plot future worth as a function of MARR

Which payments come at the beginning of each period : What is the present value of a 7-year annuity of $2,500 per period in which payments come at the beginning of each period?

Drill for oil off northeast coast of florida : Florida Seaside Oil Exploration Company is deciding whether to drill for oil off the northeast coast of Florida.

Simple payback period and internal rate of return : Derive an analytical relationship between simple payback period and internal rate of return (IRR) over a 15-year assessment period

Would you invest in the treasury bill that you can rollover : Current investment opportunity interest rates are 5% and are expected to increase to 7% in 6 months. Would you invest in the Treasury bill that you can rollover

User Account

All Pages