Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

How to make a cash flow statement over a 3 year period? With the following figures from the income statement and balance sheet? Year 1

How to make a cash flow statement over a 3 year period? With the following figures from the income statement and balance sheet?

image text in transcribed

Year 1 Year 3 $ 42,021 100.00% 100.00% $ 150,000 100.00% 33.33% Revenue: Total Revenue Operating Expenses: Payroll Expense Insurance Truck expense Equipment expense Gas Repairs Advertising Misc Startup Cost Total Expenses Net Profit 25,56% 1.56% 8.00% 8.59% Income Statement Year 2 Revenue Total Revenue $ $ 90,000 Operating Expenses Payroll expense $ 23,000 Insurance $ $ 1,400 Truck expense $ $ 7,200 Equipment expense $ 7,728 Gas $ 10,000 Repairs $ 10,000 Advertising $ $ 2,000 Misc $ 1,000 $ 11,333 $ 1,100 S $ 7,200 $ 7,728 $ 3,000 $ $ $ 500 $ 14,000 $ 51,061 $ (9,040) 11.11% Revenue Total Revenue Operating Expenses Payroll expense Insurance Truck expense Equipment expense Gas Repairs Advertising Misc 26.97% 2.62% 17.13% 18.39% 7.14% 11.90% 2.86% 1.19% 33.32% 121.51% -21.51% $ 50,000 $ 1,400 $ 7,200 $ 7,728 $ 17,000 $ 15,000 $ 700 $ 2,000 0.93% 4.80% 5.159 11.33% 10.00% 0.47% 1.33% 5,000 1,200 11.11% 2.22% 1.11% Total Expenses Net Profit $ 62,328 $ 27,672 69.25% 30.75% Total Expenses Net Profit $ 101,028 $ 48,972 67.35% 32.65% Cash End of Year 1 Assets: Current Assets: $ 5,000 Prepaid Expenses $ 1,000 Total Current Assets $ 6,000 Fixed Assets: Truck $ 28,200 Equipment $ 8,000 Total Fixed Assets $ 36,200 Balance Sheet End of Year 2 Assets: Current Assets: Cash $ 15,500 Prepaid Expenses $ 2,000 Total Current Assets $ 17,500 Fixed Assets: Truck $ 35,400 Equipment $ 15,720 Total Fixed Assets $ 51,120 End of Year 3 Assets: Current Assets: Cash $ 25,000 Prepaid Expenses $ 3,500 Total Current Assets $ 28,500 Fixed Assets: Truck $ 42,600 Equipment $ 23,360 Total Fixed Assets $ 65,960 Less Acumulated Depriciation $ 15,000 Total Assets $ 27,200 Less Acumulated Depriciation $ 15,000 Total Assets $ 53,620 Less Acumulated Depriciation $ 14,800 Total Assets $ 79,660 Liabilities & Equity: Liabilities: Notes Payable $ 20,550 Vehicle Balance $ 15,000 Total Liabilities $ 35,550 Equity: Owner, Capital $ (8,350) Total Liabilities & Equity $ 27,200 Liabilities & Equity: Liabilities: Notes Payable $ 20,620 Vehicle Balance $ 7,800 Total Liabilities $ 28,420 Equity: Owner, Capital $ 25,200 Total Liabilities & Equity $ 53,620 Liabilities & Equity: Liabilities: Notes Payable $ 5,830 Vehicle Balance $ 600 Total Liabilities $ 6,430 Equity: Owner, Capital $ 73,230 Total Liabilities & Equity $ 79,660

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental financial accounting concepts

Authors: Thomas P. Edmonds, Frances M. Mcnair, Philip R. Olds, Edward

8th edition

978-0078025365

Students also viewed these Accounting questions