Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am trying to create a statement of cash flows from a balance sheet and income statement but am not sure which items go in

I am trying to create a statement of cash flows from a balance sheet and income statement but am not sure which items go in Operating, Financing and Investing. I am looking to try and create this statement in excel so I can learn what goes where.

image text in transcribed Year +1 Year +2 Year +3 Year +4 Year +5 Year +1 Year +2 Year +3 Year +4 Year +5 Net Cash Flow from Operations Revenues Cost of Sales Gross Profit Accounting Advertising & Promotion Bank Charges Compensation & Benefits Consulting Fees Insurance Lease - Facilities Legal & Professional Licenses & Fees Maintenance Miscellaneous Office supplies Security Telephone Utilities Website Total Operating Exp. EBIDTA Depreciation Operating Profit Interest Expense Earnings Before Taxes Income Taxes Net Income Balance Sheet Cash Inventory Prepaid Leases Total Current Assets Fixed Assets Less: Depreciation Net Fixed Assets Total Assets Accounts Payable Long Term Debt Total Liabilities Owner's Equity Paid-in Capital Retained Earnings Total Liabilities & Equity $3,181,360 $1,953,991 $1,227,369 $9,660 $24,150 $66,809 $397,095 $3,864 $1,610 $540,960 $805 $805 $966 $2,898 $4,347 $1,159 $2,898 $6,762 $2,898 $1,067,686 $159,683 $7,915 $151,768 $69,550 $82,218 $28,776 $53,442 $3,340,428 $2,051,691 $1,288,737 $10,143 $19,900 $70,149 $409,008 $0 $1,691 $540,960 $805 $821 $985 $2,956 $4,434 $1,195 $2,956 $7,100 $2,898 $1,076,000 $212,737 $7,915 $204,823 $64,841 $139,981 $48,994 $90,988 $3,507,449 $2,154,275 $1,353,174 $10,650 $20,497 $73,656 $421,277 $0 $1,776 $540,960 $805 $837 $1,005 $3,016 $4,522 $1,230 $3,016 $7,456 $2,898 $1,093,601 $259,574 $7,915 $251,659 $59,665 $191,994 $67,198 $124,796 $3,682,822 $2,261,989 $1,420,833 $11,183 $21,112 $77,340 $433,916 $0 $1,864 $540,960 $805 $855 $1,026 $3,075 $4,613 $1,267 $3,075 $7,828 $2,898 $1,111,816 $309,017 $7,915 $301,102 $53,974 $247,129 $86,496 $160,633 $3,866,962 $2,375,088 $1,491,874 $11,742 $21,745 $81,207 $446,933 $0 $1,958 $540,960 $805 $871 $1,045 $3,136 $4,706 $1,304 $3,136 $8,219 $2,898 $1,130,664 $361,210 $7,915 $353,295 $47,719 $305,576 $106,951 $198,626 Begin Year +1 Year +2 Year +3 Year +4 Year +5 $53,372 $178,222 $339,222 $391,647 $473,073 $585,026 $684,250 $684,250 $683,897 $718,092 $753,997 $791,697 $45,080 $45,080 $45,080 $45,080 $45,080 $45,080 $782,702 $907,552 $1,068,200 $1,154,819 $1,272,150 $1,421,802 $54,499 $54,499 $54,499 $54,499 $54,499 $54,499 $0 $7,915 $15,830 $23,743 $31,659 $39,572 $54,499 $46,584 $38,669 $30,756 $22,839 $14,926 $837,200 $954,136 $1,106,869 $1,185,575 $1,294,989 $1,436,729 $0 $110,942 $224,843 $236,086 $247,888 $260,284 $753,480 $706,032 $653,874 $596,540 $533,517 $464,237 $753,480 $816,974 $878,717 $832,626 $781,405 $724,521 $0 $0 $0 $0 $0 $0 $83,720 $83,720 $83,720 $83,720 $83,720 $83,720 $0 $53,442 $144,431 $269,229 $429,864 $628,488 $837,200 $954,136 $1,106,869 $1,185,575 $1,294,989 $1,436,729 Decrease (Increase) in Cash Required for Operations Net Cash Flow from Investing Net Cash Flow from Debt Financing Net Cash Flow into Financial Assets Net Cash FlowPref. Stock and Noncontrolling Interests Free Cash Flows for All Debt and Equity Net Cash Flow from Operations Add back: Interest Expense after tax Subtract: Interest Income after tax Decrease (Increase) in Cash Required for Operations Free Cash Flow from Operations Net Cash Flow from Investing Add back: Net CFs into Financial Assets Free Cash Flows - All Debt and Equity Year +1 Year +2 Year +3 Year +4 Year +5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Financial Accounting

Authors: Robert Libby, Patricia Libby, Frank Hodge

10th edition

1259964949, 1259964947, 978-1259964947

More Books

Students also viewed these Accounting questions