Prepare a cash flow statement based on the info provided on the income statement. GROSS REVENUES Beer
Fantastic news! We've Found the answer you've been seeking!
Question:
Prepare a cash flow statement based on the info provided on the income statement.
Transcribed Image Text:
GROSS REVENUES Beer Liquor Food Soda/Snacks Arcade Parties Whirlyball TOTAL GROSS REVENUES COST OF GOODS Beer Liquor Food Soda/Snacks TOTAL COST OF GOODS GROSS PROFIT PROJECTED INCOME STATEMENTS For The Period Ending: Year 1 $40,000 $20,000 $30,100 $10,300 $17,500 $11,200 $150,000 $279,100 $16,000 $5,000 $15,050 $3,090 $39,140 $239,960 Year 2 $48,000 $24,000 $36,120 $12,360 $21,000 $13,440 $180,000 $334,920 $19,200 $6,000 $18,060 $3,708 $46,968 $287,952 Year 3 $62,400 $31,200 $46,956 $16,068 $27,300 $17,472 $234,000 $435,396 $24,960 $7,800 $23,478 $4,820 $61,058 $374,338 GROSS PROFIT CASH PAID OUT Wages Payroll Taxes Insurance Water Test/Other License Music/Entertainment Office Supplies/Postage Legal/Accounting Building/Equipment Repair Janitorial Supplies Property Tax Cable Heat/Coal Electric Propane Telephone Security System Septic Service Snow Plowing Trash Depreciation Amortization Interest Expense Miscellaneous $239,960 $15,000 $2,250 $4,500 $250 $10,000 $250 $500 $2,000 $3,000 $2,000 $3,000 $400 $2,000 $6,000 $2,200 $300 $300 $300 $2,000 $700 $9,400 $200 $10,013 $2,791 $287,952 $15,750 $2,363 $4,725 $263 $10,500 $263 $525 $2,100 $3,150 $2,100 $3,150 $420 $2,100 $6,300 $2,310 $315 $315 $315 $2,100 $735 $9,318 $200 $9,757 $3,349 $374,338 $16,538 $2,481 $4,961 $276 $11,025 $276 $551 $2,205 $3,308 $2,205 $3,308 $441 $2,205 $6,615 $2,426 $331 $331 $331 $2,205 $772 $9,318 $200 $9,483 $4,354 TOTAL EXPENSES NET INCOME $79,354 $160,606 $82,422 $205,530 $86,142 $288,195 PERIOD ENDING: Current assets Cash and cash equivalents Short-term investments Net receivables Inventory Other current assets Total current assets Long-term assets Long-term investments Fixed assets Accumulated Depreciation Security Deposit Other assets Total assets Current liabilities Accounts payable Short-Term Debt/Current portion of long-term debt Other current liabilities Total current liabilities Long-term debt Other liabilities Total liabilities 12/31/2015 155,222 49,900 205,122 155,500 (31,100) 6,400 335,922 7,500 18,837 26,337 564,696 591,033 12/31/2016 12/31/2017 152,435 74,850 227,285 155,500 (62,200) 6,400 326,985 7,500 19,793 27,293 557,196 584,489 249,449 87,325 336,774 155,500 (93,300) 6,400 405,374 7,500 20,798 28,298 537,402 565,700 Owner's Equity Equity Investment Capital surplus Retained earnings Total equity Total liabilities & equity 75,000 1,500 76,500 667,533 331,611 75,000 2,300 77,300 661,789 334,804 75,000 3,100 78,100 643,800 238,426 GROSS REVENUES Beer Liquor Food Soda/Snacks Arcade Parties Whirlyball TOTAL GROSS REVENUES COST OF GOODS Beer Liquor Food Soda/Snacks TOTAL COST OF GOODS GROSS PROFIT PROJECTED INCOME STATEMENTS For The Period Ending: Year 1 $40,000 $20,000 $30,100 $10,300 $17,500 $11,200 $150,000 $279,100 $16,000 $5,000 $15,050 $3,090 $39,140 $239,960 Year 2 $48,000 $24,000 $36,120 $12,360 $21,000 $13,440 $180,000 $334,920 $19,200 $6,000 $18,060 $3,708 $46,968 $287,952 Year 3 $62,400 $31,200 $46,956 $16,068 $27,300 $17,472 $234,000 $435,396 $24,960 $7,800 $23,478 $4,820 $61,058 $374,338 GROSS PROFIT CASH PAID OUT Wages Payroll Taxes Insurance Water Test/Other License Music/Entertainment Office Supplies/Postage Legal/Accounting Building/Equipment Repair Janitorial Supplies Property Tax Cable Heat/Coal Electric Propane Telephone Security System Septic Service Snow Plowing Trash Depreciation Amortization Interest Expense Miscellaneous $239,960 $15,000 $2,250 $4,500 $250 $10,000 $250 $500 $2,000 $3,000 $2,000 $3,000 $400 $2,000 $6,000 $2,200 $300 $300 $300 $2,000 $700 $9,400 $200 $10,013 $2,791 $287,952 $15,750 $2,363 $4,725 $263 $10,500 $263 $525 $2,100 $3,150 $2,100 $3,150 $420 $2,100 $6,300 $2,310 $315 $315 $315 $2,100 $735 $9,318 $200 $9,757 $3,349 $374,338 $16,538 $2,481 $4,961 $276 $11,025 $276 $551 $2,205 $3,308 $2,205 $3,308 $441 $2,205 $6,615 $2,426 $331 $331 $331 $2,205 $772 $9,318 $200 $9,483 $4,354 TOTAL EXPENSES NET INCOME $79,354 $160,606 $82,422 $205,530 $86,142 $288,195 PERIOD ENDING: Current assets Cash and cash equivalents Short-term investments Net receivables Inventory Other current assets Total current assets Long-term assets Long-term investments Fixed assets Accumulated Depreciation Security Deposit Other assets Total assets Current liabilities Accounts payable Short-Term Debt/Current portion of long-term debt Other current liabilities Total current liabilities Long-term debt Other liabilities Total liabilities 12/31/2015 155,222 49,900 205,122 155,500 (31,100) 6,400 335,922 7,500 18,837 26,337 564,696 591,033 12/31/2016 12/31/2017 152,435 74,850 227,285 155,500 (62,200) 6,400 326,985 7,500 19,793 27,293 557,196 584,489 249,449 87,325 336,774 155,500 (93,300) 6,400 405,374 7,500 20,798 28,298 537,402 565,700 Owner's Equity Equity Investment Capital surplus Retained earnings Total equity Total liabilities & equity 75,000 1,500 76,500 667,533 331,611 75,000 2,300 77,300 661,789 334,804 75,000 3,100 78,100 643,800 238,426
Expert Answer:
Answer rating: 100% (QA)
PROJECTED ANNUAL CASH FLOW STATEMENT For the Period Ending End Year 1 End Year 2 End Y... View the full answer
Related Book For
Small Business Management Launching and Growing Entrepreneurial Ventures
ISBN: 978-1305405745
18th edition
Authors: Justin G. Longenecker, J. William Petty, Leslie E. Palich, Frank Hoy
Posted Date:
Students also viewed these finance questions
-
Following is a preparation of a cash flow statement based on the balance sheet, income statement, and additional transaction information provided. Prepare the cash flow statement. Balance Sheet as of...
-
Prepare a cash flow statement for the firm for 2014 and 2015.
-
You will prepare a Cash Flow Statement for Clarks Sporting Goods and then you will calculate ratios for Sams Paint and Drywall. Case 1: Clarks Sporting Goods Dave Clark plans to open a sporting goods...
-
The cost formula for the maintenance department of Rainbow, Ltd., is $19,400 per month plus $7,70 per machine hour used by the production department. Required: a. Calculate the maintenance cost that...
-
Explain relationships between patents and copyrights.
-
The equation for the demand curve for writing paper in Belgium is Q D = 350 - ( P /2) [or P =700 - 2 Q D ] The equation for the supply curve for writing paper in Belgium is Q S = 220+ 5 P [or P = 40...
-
Ken loans his grandson Rex $20,000 at 5.5 percent per year to help pay for executive chef schooling in Florida. Rex requires 3 years of schooling before beginning to earn a salary. He agrees to pay...
-
The Perez Company has the opportunity to invest in one of two mutually exclusive machines that will produce a product it will need for the foreseeable future. Machine A costs $10 million but realizes...
-
People will take the opportunity to review the Netflix documentary called 'The Social Dilemma.' Upon reviewing the documentary, each group will discuss both roles as a marketer and an individual user...
-
Under a periodic inventory system, purchases are Multiple choice question. recorded in a separate temporary account which is closed at period end recorded in a separate temporary account which is not...
-
A Ltd has borrowed the following loans from a bank. -A loan of $1m to finance its business activities in Hong Kong, and -A loan of $1.8m to finance its offshore business The two loans are secured by...
-
Derive Equations 5.41 and 5.42 for the spectra of a classical free rotor, and plot them using reduced units: * = (I/k B T )1/2 . Do not worry about finding a closed form expression for the TCF of...
-
The following is a set of activity-coefficient data for a binary liquid system as determined from VLE data: Inspection of these experimental values suggests that they are noisy, but the question is...
-
(a) Fit the Margules two-parameter equation to the n-pentane(1) + acetone(2) system P-x-y data below at 1 bar (Lo et al. 1962. J. Chem. Eng. Data 7:32) by fitting to x 1 = 0.503. Plot the resultant...
-
After fitting the two-parameter Margules equation to the data below, generate a P-x-y diagram at 78.15 C. Data at 78.15C: psat = 1.006 bar 1 psat = 0.439 bar = 1.6931; 2 = 1.9523
-
Weve approached only personal leadership so fardeveloping skills to lead yourself and avoid being reactive. Before we work on leading others, reflect on what leadership means to you now. Some...
-
All patients who have trisomy of autosome 21 who survive to adulthood develop which one of the following conditions? (A) Alzheimers disease (B) lewy body dementia (C) multi-infarct dementia (D) Pick...
-
One of the significant and relevant accounts for this cycle is equipment. For this account, what would typically be the most relevant assertions for the auditor to consider? Why is it important for...
-
$1000 Deposited in a CD earning interest of 1.5% per year-How much can be withdrawn at the end of 10 years? Answer the following: a. Draw Cash Diagram b. Calculation Method c. Factor Notation Method...
-
What do you believe would be the two most desirable and undesirable qualities of an entrepreneur?
-
Describe DashLockers competitive advantage.
-
What do you like about this executive summary? What do you dislike? Hyper Wear was founded in 2008 to participate in the functional fitness market, along with such recognized brands as CrossFit and...
-
Compare and contrast open market operations and reserve requirement.
-
Compare and contrast monetary policy and fiscal policy.
-
Compare and contrast positive and negative externalities.
Study smarter with the SolutionInn App