Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Gamma Company is considering an investment opportunity with the expected net cash inflows of $ 3 0 0 , 0 0 0 for four years.

image text in transcribed
Gamma Company is considering an investment opportunity with the expected net cash inflows of $300,000 for four years. Residual value of the investment would be $70,000. The company uses a discount rate of 15% and the initial investment is $290,000. Calculate the Net Present Value of the investment.
Please round your final answer to the nearest whole dollar. Do not enter "$" or commas in your answer.
OPTIONAL: If you wish to use Excel to solve this problem, please click here.
Please note when the excel file is loaded, it will only show 1 empty cell. Please click on a new worksheet at the bottom and a new sheet with multiple cells will be populated. Also, the excel file has limited capabiliites. To use the net present value function, it will be required to type in =NPV(). Finally, it may be necesssary to widen the columns to see the full number result of the formula.
TABLE 3 Present Value of 1
\table[[(n) Periods,4%,5%,6%,7%,8%,9%,10%,11%,12%,],[1,.96154,.95238,.94340,.93458,.92593,.91743,.90909,.90090,.89286,.86957],[2,.92456,.90703,.89000,.87344,.85734,.84168,.82645,.81162,.79719,.75614],[3,.88900,.86384,.83962,.81630,.79383,.77218,.75132,.73119,.71178,.65752],[4,.85480,.82270,.79209,.76290,.73503,.70843,.68301,.65873,.63552,.57175],[5,.82193,.78353,.74726,.71299,.68058,.64993,.62092,.59345,.56743,.49718]]
TABLE 4 Present Value of an Annuity of 1
\table[[(n) Payments,4%,5%,6%,7%,8%,9%,10%,11%,,],[1,.96154,.95238,.94340,.93458,.92593,.91743,.90909,.90090,.89286,.86957],[2,1.88609,1.85941,1.83339,1.80802,1.78326,1.75911,1.73554,1.71252,1.69005,1.62571],[3,2.77509,2.72325,2.67301,2.62432,2.57710,2.53130,2.48685,2.44371,2.40183,2.28323],[4,3.62990,3.54595,3.46511,3.38721,3.31213,3.23972,3.16986,3.10245,3.03735,2.85498],[5,4.45182,4.32948,4.21236,4.10020,3.99271,3.88965,3.79079,3.69590,3.60478,3.35216]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

John E Freunds Mathematical Statistics With Applications

Authors: Irwin Miller, Marylees Miller

8th Edition

978-0321807090, 032180709X, 978-0134995373

Students also viewed these Accounting questions

Question

e. What age client does the person see?

Answered: 1 week ago