This is apart of a business plan and I know I may have did...

80.2K

Verified Solution

Question

Accounting

imageimageimageimage

This is apart of a business plan and I know I may have did a few things wrong when it comes to the balance sheet and maybe the other statements? I need help with what I've possibly missed or could fix. It's a three year plan for a simple coffee shop.

2020 136,575 $ 47,801 $ 88,774 $ 65% 2021 170,719 59,752 110,967 65% 52,800 - $ $ 52,800 . Projected Income 2019 Revenue $ 91,050 $ Cost of Goods $ 31,868 $ Gross Margin $ 59,183 $ Gross Margin % 65% Fixed Costs Mortgage $ 52,800 $ Remodel $ 5,000 $ Variable Costs Legal $ 2,100 $ Marketing and Sales 187 $ Insurance 741 $ Utilities 9,000 $ Payroll 25,000 $ Coffee Beans 626 $ Tea 200 $ Coffee Filters 117 $ Retail Supplies 690 $ Cups 700 $ Miscellaneous Inventory Fund 750 $ Total Expenses $ 97,911 $ Not incomo 120 7201 1,000 $ 170 $ 754 $ 9,500 $ 35,000 $ 637 $ 200 $ 147 $ 690 $ 712 $ 600 $ 102,210 $ 112 1261 900 150 767 9,800 35,000 648 200 188 713 724 550 102,440 0527 3 Total Expenses 4 Net income $ $ 97,911 $ (38,729) $ 102,210 $ (13,436) $ 102,440 8,527 UI Beginning balance ) Cash inflow I Cash outflow 2 Loan Repayment 3 Ending Cash Balance Cash Flow Statement 2019 $ 60,000 $ $ 59,183 $ $ 88,911 $ $ 20,000 $ $ 10,272 $ 2020 10,272 $ 88,774 $ 92,710 $ 20,000 $ 6,336 $ 2021 6,336 110,967 92,640 20,000 24,663 $ $ $ $ Balance Sheet 2019 2020 2021 60,000 10,272 $ 6,336 3,083 $ 2,986 3,023 741 $ 754 $ 767 63,824 $ 14,012 $10,126 $ Assets Cash/Short Term Investment Inventory Prepaid Insurance Total Current Assets Equipment Furniture Cash Register Office Equipment Refrigerators Ice Machine Expresso Machine Coffee Brewer Total Equipment Total Assets $ $ $ 7,130 $ 7,130 $ 7,130 419 $ 419 $ 419 1,555 $ 1,555 $ 1,555 1,975 $ 1,975 $ 1,975 430 $ 430 $ 430 4,450 $ 4,450 $ 4,450 959 $ 959 $ 959 16,918 $ 16,918 $ 16,918 80,742 $ 30,930 $ 27,044 $ $ $ $ 20,000 $ 20,000 $20,000 Liabilities & Equity Liabilities Notes Payable Equity Owner Investment Retained Earnings Total Equity Total Liabilities & Equity $ $ $ $ 60,000 0 0 (38,729) $(13,436) $ 8,527 21,272 $(13,436) $ 8,527 41,272 $ 6,564 $ 28,527

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students