Question: i just need formula how can i take answer for line 30 PVFCTSP Compatibiliny Medel-Ence HOME NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ood I

i just need formula how can i take answer for line 30  i just need formula how can i take answer for line

PVFCTSP Compatibiliny Medel-Ence HOME NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ood I Pine valley Furniture A1 Pine Valley Furnture Economic Feasibility Analysis Customer Tracking System Project 2 Year of Project Year 2 earo Year 1 Year 3 Year 4 Year 5 TOTALS Net economic benefit Discount Rate (12%) SO $50,000 $50,000 $50,000 $50,000 0.6355 $50,000 0 5674 7 8 0 8929 0 7972 0 7118 10 1 NPV of al BENEFITS $4643 84,503 $120,092 $151,867 $180239 $180,23 13 One-time COSTS ($42,500) 15 Recurring Costs 16:Discount Rate (12%) 7 PV of Recuring Costs so ($28,500) (528,500) ($28,500) ($28,500) ($28,500) $0 (S25446) ($22,720)($2028($18,112) $16,172) 0 8929 0 7972 0 7118 0 6355 0 5674 . 19 NPV of All COSTS ($42,500) ($67946) ($90,666) ($110.952) ($129,064) ($145 236) ($145,236) 20 22 Overalil NPV 23 24 26 Overall ROI-(Overall NPVINPV of All COSTS) 26 $35,003 0.24 Break-Even Analysis 29 Yeax NYCash F$42500) $19,198 $17.140 $15,303 $13.664 $12,200 0Overall NPV Cash Flow ($42,500) ($23,304) (S6,164) $9,139 $22,803 $35,003 31 2 Project break-even occurs between years 2 and 3 3 Use first year of positive cash flow to calculate break-even fraction-((15303-9139)/ 15303)403 4 Actual break-even occurred at 2.4 years 35 PVF-CTSP

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!