Capital Budegting Exam Spreadsheet

Capital Budegting Exam Spreadsheet - $30,000.00 $61,200.00...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Biogen Transportation Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Initial Outlay -$2,500,000.00 Contract Penalty -$2,500,000.00 Upgrade Costs -$3,000,000.00 Cost Savings $1,600,000.00 $1,664,000.00 $1,730,560.00 $1,799,782.40 $1,871,773.70 Operating Expenses -$850,000.00 -$884,000.00 -$919,360.00 -$956,134.40 -$994,379.78 Depreciation Expense -$750,000.00 -$750,000.00 -$750,000.00 -$250,000.00 Taxable Income $0.00
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $30,000.00 $61,200.00 $593,648.00 $877,393.92 Tax $0.00-$9,000.00-$18,360.00-$178,094.40-$263,218.18 Free Cash Flows-$8,000,000.00 $750,000.00 $771,000.00 $792,840.00 $665,553.60 $614,175.74 Terminal Cash Flow $8,837,061.06 NPV $153,765.09 B/T A/T Weight WACC calculation Rd (Bill) 0.080 0.056 0.250 Rd (Debenture) 0.100 0.070 0.250 Re 0.156 0.156 0.500 WACC A/T 0.1095...
View Full Document

This note was uploaded on 03/09/2012 for the course FINC corporate taught by Professor Kim during the Three '11 term at University of Sydney.

Ask a homework question - tutors are online