MBA 620

Can you please help me with answering the spreadsheet of Capital Budgeting and explanation in word document on how to get the result without using numerical numbers.
Question 1
MACRS
Depreciation $350
Year 7 Year class Depreciation
1 14.29% $50.02
2 24.49% $85.72
3 17.49% $61.22
4 12.49% $43.72
5 8.93% $31.26
6 8.92% $31.22
7 8.93% $31.26
8 4.46% $15.61
$350.00
Question 2 Question 3 cash flows
A B C D E F Cash flows Year
Year Cash from Revenue in $Millions Cash outflow, expenses in $Millions Depreciation in $Millions Taxable Income in $ Millions Tax  in $Millions 27.5% rate After tax Cash Flow In $Millions 0
1 $1,800 $1,728 $50.02 $21.99 $6.05 $65.95 $65.95 1
2 $1,900 $1,824 $85.72 -$9.72 -$2.67 $78.67 $78.67 2
3 $2,000 $1,920 $61.22 $18.79 $5.17 $74.83 $74.83 3
4 $2,100 $2,016 $43.72 $40.29 $11.08 $72.92 $72.92 4
5 $2,200 $2,112 $31.26 $56.75 $15.60 $72.40 $72.40 5
6 $2,300 $2,208 $31.22 $60.78 $16.71 $75.29 $75.29 6
7 $2,400 $2,304 $0.00 $96.00 $26.40 $69.60 $69.60 7
8 $2,500 $2,400 $0.00 $100.00 $27.50 $72.50 $72.50 8
9 $2,600 $2,496 $0.00 $104.00 $28.60 $75.40 $75.40 9
10 $2,700 $2,592 $0.00 $108.00 $29.70 $78.30 $78.30 10
11 $2,600 $2,496 $0.00 $104.00 $28.60 $75.40 $75.40 11
12 $2,500 $2,400 $0.00 $100.00 $27.50 $72.50 $72.50 12
13 $2,400 $2,304 $0.00 $96.00 $26.40 $69.60 $69.60 13
14 $2,200 $2,112 $0.00 $88.00 $24.20 $63.80 $63.80 14
15 $2,000 $1,920 $0.00 $80.00 $22.00 $58.00 $58.00 15
16 $1,800 $1,728 $0.00 $72.00 $19.80 $52.20 $52.20 16
17 $1,500 $1,440 $0.00 $60.00 $16.50 $43.50 $43.50 17
18 $1,200 $1,152 $0.00 $48.00 $13.20 $34.80 $34.80 18
19 $800 $768 $0.00 $32.00 $8.80 $23.20 $23.20 19
20 $400 $384 $0.00 $16.00 $4.40 $11.60 $11.60 20
$0.00 21
Question 3
NPV IRR
Question 4 Question 5 cash flows
A B C D E F Cash flows Year
TOTAL CASH FLOW YEAR ZERO Year Cash from Revenue in $Millions Cash outflow, expenses in $Millions Depreciation in $Millions Taxable Income in $ Millions Tax  in $Millions 27.5% rate in years 1 , 2, 3 and 50% there after After tax Cash Flow In $Millions 0
350,000,000.00 1 $1,800 $1,762.56 $50.02 -$12.57 -$3.46 $40.90 $40.90 1
2 $1,900 $1,860.48 $85.72 -$46.20 -$12.70 $52.22 $52.22 2
3 $2,000 $1,958.40 $61.22 -$19.62 -$5.39 $46.99 $46.99 3
4 $2,100 $2,056.32 $43.72 -$0.04 -$0.02 $43.70 $43.70 4
5 $2,200 $2,154.24 $31.26 $14.50 $7.25 $38.51 $38.51 5
6 $2,300 $2,252.16 $31.22 $16.62 $8.31 $39.53 $39.53 6
7 $2,400 $2,350.08 $31.26 $18.67 $9.33 $40.59 $40.59 7
8 $2,500 $2,448.00 $15.61 $36.39 $18.20 $33.81 $33.81 8
9 $2,600 $2,545.92 $350.00 -$295.92 -$147.96 $202.04 $202.04 9
10 $2,700 $2,643.84 $0.00 $56.16 $28.08 $28.08 $28.08 10
11 $2,600 $2,545.92 $0.00 $54.08 $27.04 $27.04 $27.04 11
12 $2,500 $2,448.00 $0.00 $52.00 $26.00 $26.00 $26.00 12
13 $2,400 $2,350.08 $49.92 $24.96 $24.96 $24.96 13
14 $2,200 $2,154.24 $45.76 $22.88 $22.88 $22.88 14
15 $2,000 $1,958.40 $41.60 $20.80 $20.80 $20.80 15
16 $1,800 $1,762.56 $37.44 $18.72 $18.72 $18.72 16
17 $1,500 $1,468.80 $31.20 $15.60 $15.60 $15.60 17
18 $1,200 $1,175.04 $24.96 $12.48 $12.48 $12.48 18
19 $800 $783.36 $16.64 $8.32 $8.32 $8.32 19
20 $400 $391.68 $8.32 $4.16 $4.16 $4.16 20
$0.00 21
Question 5
NPV IRR