Sales VC Complete the shaded cells below: Year 1 $32,960,000 13,440,000 Year 2 Year 3 Year 4 $54,590,000 22,260,000 $44,805,000 18,270,000 $40,170,000 Year 5 $27,810,000 16,380,000 11,340,000 Fixed costs 5,300,000 5,300,000 5,300,000 5,300,000 5,300,000 Dep EBT 5,501,650 $8,718,350 9,428,650 6,733,650 4,808,650 3,438,050 $17,601,350 $14,501,350 $13,681,350 $7,731,950 Tax NI $6,800,313 +Dep OCF 1,918,037 5,501,650 $12,301,963 3,872,297 $13,729,053 5,501,650 $19,230,703 3,190,297 3,009,897 1,701,029 $11,311,053 $10,671,453 $6,030,921 5,501,650 $16,812,703 5,501,650 $16,173,103 5,501,650 $11,532,571 NWC Beg End $0 0 NWC CF $6,592,000 $10,918,000 $8,961,000 $8,034,000 $5,562,000 Net CF Salvage BV of equipment Taxes Salvage CF Net CF Time 0 2 3 5 12345
Sales VC Complete the shaded cells below: Year 1 $32,960,000 13,440,000 Year 2 Year 3 Year 4 $54,590,000 22,260,000 $44,805,000 18,270,000 $40,170,000 Year 5 $27,810,000 16,380,000 11,340,000 Fixed costs 5,300,000 5,300,000 5,300,000 5,300,000 5,300,000 Dep EBT 5,501,650 $8,718,350 9,428,650 6,733,650 4,808,650 3,438,050 $17,601,350 $14,501,350 $13,681,350 $7,731,950 Tax NI $6,800,313 +Dep OCF 1,918,037 5,501,650 $12,301,963 3,872,297 $13,729,053 5,501,650 $19,230,703 3,190,297 3,009,897 1,701,029 $11,311,053 $10,671,453 $6,030,921 5,501,650 $16,812,703 5,501,650 $16,173,103 5,501,650 $11,532,571 NWC Beg End $0 0 NWC CF $6,592,000 $10,918,000 $8,961,000 $8,034,000 $5,562,000 Net CF Salvage BV of equipment Taxes Salvage CF Net CF Time 0 2 3 5 12345
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Transcribed Image Text:Sales
VC
Complete the shaded cells below:
Year 1
$32,960,000
13,440,000
Year 2
Year 3
Year 4
$54,590,000
22,260,000
$44,805,000
18,270,000
$40,170,000
Year 5
$27,810,000
16,380,000
11,340,000
Fixed costs
5,300,000
5,300,000
5,300,000
5,300,000
5,300,000
Dep
EBT
5,501,650
$8,718,350
9,428,650
6,733,650
4,808,650
3,438,050
$17,601,350
$14,501,350
$13,681,350
$7,731,950
Tax
NI
$6,800,313
+Dep
OCF
1,918,037
5,501,650
$12,301,963
3,872,297
$13,729,053
5,501,650
$19,230,703
3,190,297
3,009,897
1,701,029
$11,311,053
$10,671,453
$6,030,921
5,501,650
$16,812,703
5,501,650
$16,173,103
5,501,650
$11,532,571
NWC
Beg
End
$0
0
NWC CF
$6,592,000
$10,918,000
$8,961,000 $8,034,000 $5,562,000
Net CF
Salvage
BV of equipment
Taxes
Salvage CF
Net CF
Time
0
2
3
5
12345
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education