Boost your Grades with us today!

MBA 620

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

MBA 620

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.