Cash Flow Business Case Example - Money-zinecom_第1頁(yè)
Cash Flow Business Case Example - Money-zinecom_第2頁(yè)
Cash Flow Business Case Example - Money-zinecom_第3頁(yè)
全文預(yù)覽已結(jié)束

下載本文檔

版權(quán)說(shuō)明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、Net Cash FlowY012345678910TotalsNet Capital CostsCapital Project Name$(8,000,000) $-$-$-$-$-$-$-$-$-$-$(8,000,000)Total Capital $(8,000,000) $-$-$-$-$-$-$-$-$-$-$(8,000,000)Operating and Maintenance CostsCost 1$(750,000) $(750,000) $(750,000) $(750,000) $(750,000) $(750,000) $(750,000) $(750,000) $(

2、750,000) $(750,000) $(7,500,000)Cost 2$(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(250,000) $(2,500,000)Escalation of Costs$(20,000) $(40,400) $(61,208) $(82,432) $(104,081) $(126,162) $(148,686) $(171,659) $(195,093) $(218,994) $(1,168,715)Tot

3、al Costs$-$(1,020,000) $(1,040,400) $(1,061,208) $(1,082,432) $(1,104,081) $(1,126,162) $(1,148,686) $(1,171,659) $(1,195,093) $(1,218,994) $(11,168,715)Revenue and Operating BenefitsNew Revenue$250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000$2,500,000Benefit

4、 1$1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $1,500,000$15,000,000Benefit 2$750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000$7,500,000Escalation of Benefits$55,000 $111,210 $168,657 $227,367 $287,369 $348

5、,691 $411,362 $475,412 $540,872 $607,771$3,233,711Total Benefits and Revenue$-$2,555,000 $2,611,210 $2,668,657 $2,727,367 $2,787,369 $2,848,691 $2,911,362 $2,975,412 $3,040,872 $3,107,771$28,233,711Cash Flow Before Taxes$(8,000,000) $1,535,000 $1,570,810 $1,607,449 $1,644,935 $1,683,288 $1,722,529 $

6、1,762,677 $1,803,753 $1,845,779 $1,888,776$9,064,996Income Tax CalculationDepreciation Expense$(1,600,000) $(2,560,000) $(1,536,000) $(921,600) $(921,600) $(460,800) $-$-$-$-$(8,000,000)Operating Cost$(1,020,000) $(1,040,400) $(1,061,208) $(1,082,432) $(1,104,081) $(1,126,162) $(1,148,686) $(1,171,6

7、59) $(1,195,093) $(1,218,994) $(11,168,715)Operating Benefits$2,555,000 $2,611,210 $2,668,657 $2,727,367 $2,787,369 $2,848,691 $2,911,362 $2,975,412 $3,040,872 $3,107,771$28,233,711Net Income Taxes$-$26,000 $395,676 $(28,579) $(289,334) $(304,675) $(504,692) $(705,071) $(721,501) $(738,312) $(755,51

8、1) $(3,625,998)Cash Flow After Taxes$(8,000,000) $1,561,000 $1,966,486 $1,578,869 $1,355,601 $1,378,613 $1,217,837 $1,057,606 $1,082,252 $1,107,467 $1,133,266$5,438,997Discounted Cash Flow (After Tax)$(8,000,000) $1,445,370 $1,685,945 $1,253,357 $996,407 $938,261 $767,444 $617,103 $584,707 $554,009

9、$524,921$1,367,525Business Case Results:Assumptions:NPV of Cash Flow$1,367,525Cost Escalation Factor2.00%IRR12.1%Benefit Escalation Factor2.20%Profitability Index1.17Income Tax Rate40.00%Simple Payback5 Years 2 MonthsDiscount Rate8.00%Discounted Payback7 Years 6 MonthsCopyright 2007 - 2015 Money-Dep

10、reciation ExpenseY012345678910TotalsNet Capital Costs(8,000,000.00)(8,000,000.00)Depreciation Expense(1,600,000.00)(2,560,000.00)(1,536,000.00)(921,600.00)(921,600.00)(460,800.00)-(8,000,000.00)Depreciation - 5 Year (MACRS)20.00%32.00%19.20%11.52%11.52%5.76%Copyright 2007 Money-Payback CalculationY0

11、12345678910TotalsSimple Cash Flow$8,000,000 $1,561,000 $1,966,486 $1,578,869 $1,355,601 $1,378,613 $1,217,837 $1,057,606 $1,082,252 $1,107,467 $1,133,266Cumulative Simple Payback$1,561,000 $3,527,486 $5,106,355 $6,461,956 $7,840,569 $9,058,406 $10,116,013 $11,198,264 $12,305,732 $13,438,997Discounted Cash Flow$8,000,000 $1,445,370 $1,685,945 $1,253,357 $996,407 $938,261 $767,444 $617,103 $584,70

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間，僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請(qǐng)與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

最新文檔

評(píng)論

0/150

提交評(píng)論