项目评估财务分析全套EXCEL表

This sheet summaries the feasibility of the project. It provides net present value, benefit cost ratio and internal rate of re The only input is the discount rate.Discount Rate 12.00%

Year

1

2

3

Gross Margin $700,000$735,000$771,750Discount Factor 10.8928571430.7971938780.711780248PV of Income

$0$625,000$585,938$549,316Total Expense

$65,000

$702,611$702,611$751,443Less Depreciation and Term Interest $64,384$92,863$69,047Cash Expenses $65,000

$638,228$609,748$682,396Discount Factor 1

0.8928571430.7971938780.711780248PV of Expenses

$65,000$569,846

$486,087$485,716

Benefits Less Costs

($65,000)$61,773$125,252$89,354PV Benefits Less PV Costs

($65,000)

$55,154

$99,850

$63,600

Total PV of Income $4,755,395Total PV of Expenses

Net Present Value Internal Rate of Return Return on Assets

-14.12%-0.57%-3.57% 3.48%

(after tax income/total PPE investment)

Payback Period (years)7

(payback period only displayed if less than 10 years)

and internal rate of return

45678910

$810,338$850,854$893,397$938,067$984,970$1,034,219$1,085,930

0.6355180780.5674268560.5066311210.4523492150.4038832280.3606100250.321973237

$514,984$482,798$452,623$424,334$397,813$372,950$349,640 $748,882$754,413$768,261$787,652$808,057$822,819$838,664 $52,374$43,025$38,176$33,249$21,531$9,694$7,517 $696,509$711,387$730,085$754,403$786,526$813,125$831,147

0.6355180780.5674268560.5066311210.4523492150.4038832280.3606100250.321973237

$442,644$403,660$369,884$341,253$317,665$293,221$267,607.07 $113,829$139,467$163,312$183,664$198,444$221,094$254,783 $72,340$79,137$82,739$83,080$80,148$79,729$82,033

8.50%12.55%16.07%19.76%24.65%29.73%33.52%

78910