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