Cash flow diagram.

Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter2: Financial Statements, Cash Flow,and Taxes
Section: Chapter Questions
Problem 20SP: Begin with the partial model in the file Ch02 P20 Build a Model.xlsx on the textbook’s Web...
icon
Related questions
Question
Cash flow diagram.
GIVEN VALUES
2021
2022
2023
2024
Gross Sales of PET bottles at
1.50 (P)
Cost of Raw material (direct
ost)
Net Sales (P)
480,000
492,000
504,300
516,907.5
96,000
98,400
|100,860
|103,381.5
384,000
393,600
403,440
413,526
1,200,000
Building Machinery and
Equipment (P)
Operating Cost (P)
1,080,000
960,000
840,000
86,000
88,150
90,353.7
92,61 2.5
Depreciation(P)
120,000
120,000
120,000
|120,000
Tax at 30%of Net sales (P)
115,200
118,080
121,032
124,057.8
Total Expense (P)
321,200
326,230
331,385.7
336,670.3
Net Income
P62,800
P67,370
P72,054.3
P76,855.7
Transcribed Image Text:GIVEN VALUES 2021 2022 2023 2024 Gross Sales of PET bottles at 1.50 (P) Cost of Raw material (direct ost) Net Sales (P) 480,000 492,000 504,300 516,907.5 96,000 98,400 |100,860 |103,381.5 384,000 393,600 403,440 413,526 1,200,000 Building Machinery and Equipment (P) Operating Cost (P) 1,080,000 960,000 840,000 86,000 88,150 90,353.7 92,61 2.5 Depreciation(P) 120,000 120,000 120,000 |120,000 Tax at 30%of Net sales (P) 115,200 118,080 121,032 124,057.8 Total Expense (P) 321,200 326,230 331,385.7 336,670.3 Net Income P62,800 P67,370 P72,054.3 P76,855.7
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Cash Flows
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage