Answered step by step
Verified Expert Solution
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.
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 +5Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started