Question
FinancialAnalysisforProjectNameCreatedby:Date:Note:Changetheinputs,showningreenbelow(i.e.interestrate,numberofyears,costs,andbenefits).Besuretodouble-checktheformulasbasedontheinputs.Discountrate8.00%AssumetheprojectiscompletedinYear0Year01234TotalCosts50,0000090Discountfactor1.000.930.860.790.74Discountedcosts50,000---50,000Benefits010,00020,00020,00020,000Discountfactor1.000.930.860.790.74Discountedbenefits09,30017,20015,80014,80057,100Discountedbenefits-costs(50,000)9,30017,20015,80014,8007,100NPVCumulativebenefits-costs(50,000)(40,700)(23,500)(7,700)(8,700)ROI14%PaybackinYear1AssumptionsEnterassumptionshere Calvulate the Project Cost and NPV?
FinancialAnalysisforProjectNameCreatedby:Date:Note:Changetheinputs,showningreenbelow(i.e.interestrate,numberofyears,costs,andbenefits).Besuretodouble-checktheformulasbasedontheinputs.Discountrate8.00%AssumetheprojectiscompletedinYear0Year01234TotalCosts50,0000090Discountfactor1.000.930.860.790.74Discountedcosts50,000---50,000Benefits010,00020,00020,00020,000Discountfactor1.000.930.860.790.74Discountedbenefits09,30017,20015,80014,80057,100Discountedbenefits-costs(50,000)9,30017,20015,80014,8007,100NPVCumulativebenefits-costs(50,000)(40,700)(23,500)(7,700)(8,700)ROI14%PaybackinYear1AssumptionsEnterassumptionshere
Calvulate the Project Cost and NPV?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
