Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 5 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Accounting Posted 18 Aug 2017 My Price 12.00

A project will cost $1 million. The company uses a 5% discount rate as a threshold

A project will cost $1 million. The company uses a 5% discount rate as a threshold for accepting capital projects. It is expected to have a 5 year life and returns (net of all costs and taxes) the following: t: 0 1 2 3 4 5 CF0 CF1 CF2 CF3 CF4 CF5 Year0 Year1 Year2 Year3 Year4 Year5 ($1,000,000) $500,000 $400,000 $300,000 $200,000 $100,000 k = 5.00% a) Calculate the Internal Rate of Return (IRR). IRR = 20.27% <== use="" "irr"="" excel="" formula="" b)="" assuming="" the="" funds="" can="" be="" invested="" at="" 3%="" [ri],="" calculate="" the="" mirr="" and="" the="" terminal="" value="" (tv).="" ri="3%" mirr="10.19%"></==><== use="" "mirr"="" excel="" formula=""></==> TV = <== tv="" is="" the="" net="" future="" value="" (nfv)="" of="" all="" [positive]="" cash="" inflows="" in="" the="" project.="" year="" nfv="" c)="" calculate="" the="" project’s="" net="" present="" value="" (npv).="" 0="" npv="$324,806.34"></==><== use="" "npv"="" excel="" formula="" 1="" 2="" 3="" d)="" calculate="" the="" profitability="" index="" (pi).="" 4="" pi=""></==><== no="" excel="" formula="" for="" this="" 5=""></==> NPV of all POSITIVE CFs: [1] Take [1] divided by [2] to get PI; monkey2 NPV of all NEGATIVE CFs: [2] ignore negative sign in [2]; PI is always positive. e) Calculate the Payback Period (PB). PB = <== no="" excel="" formula="" for="" this="" f)="" calculate="" the="" discounted="" payback="" period="" (dpb).=""></==> DPB = <== no excel formula for this no="" excel="" formula="" for="" this=""></== no excel formula for this >

Answers

Alpha Geek
(8)
Status NEW Posted 18 Aug 2017 11:08 AM My Price 12.00

 t----------- ye-----------ar -----------Cas-----------h f-----------low----------- Pr-----------ese-----------nt -----------val-----------ue -----------fac-----------tor----------- at----------- co-----------st -----------of -----------cap-----------ita-----------l =-----------5% -----------Dis-----------cou-----------nte-----------d c-----------ash----------- fl-----------ow -----------0 0----------- C0----------- (1-----------,00-----------0,0-----------00.-----------00)----------- 1 -----------(1,-----------000-----------,00-----------0.0-----------0) -----------1 1----------- C1----------- 50-----------0,0-----------00.-----------00 -----------0.9-----------524----------- 47-----------6,2-----------00.-----------00

Attachments

file 1503055623-2263666_1_636383975357347322_A-project-cost-1million.xlsx preview (98 words )
ye-----------arC-----------ash----------- fl-----------owD-----------isc-----------oun-----------ted----------- ca-----------sh -----------flo-----------wC0-----------C1C-----------2C3-----------C4C-----------5IR-----------RNP-----------VtP-----------res-----------ent----------- va-----------lue----------- fa-----------cto-----------r a-----------t c-----------ost----------- of----------- ca-----------pit-----------al -----------=5%----------- Re-----------inv-----------est-----------ed -----------for----------- 4 -----------yea-----------rs ----------- Re-----------inv-----------est-----------ed -----------for----------- 3y-----------ear-----------s -----------Rei-----------nve-----------ste-----------d f-----------or -----------2 y-----------ear-----------s -----------Rei-----------nve-----------ste-----------d f-----------or -----------1 y-----------ear-----------s -----------Fut-----------ure----------- va-----------lue----------- of----------- ne-----------t c-----------ash----------- in-----------flo-----------wca-----------n n-----------ot -----------be -----------rei-----------nve-----------ste-----------dte-----------rmi-----------nal----------- va-----------lue-----------MIR-----------R f-----------or -----------fun-----------ds -----------inv-----------est-----------ed -----------at -----------3%i-----------nit-----------ial----------- in-----------ves-----------tme-----------nt -----------=10-----------000-----------00c-----------umu-----------lat-----------ive----------- ca-----------sh -----------flo-----------wpa-----------y b-----------ack----------- pe-----------rio-----------d=2-----------+ 1-----------000-----------00/-----------300-----------000-----------pay----------- ba-----------ck -----------per-----------iod-----------=2+-----------0.3-----------4=2-----------.34----------- ye-----------ars-----------whe-----------re -----------A i-----------s l-----------ast----------- pe-----------rio-----------d w-----------ith----------- a -----------neg-----------ati-----------ve
Not Rated(0)