Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need to find balance sheet for june 30,2022 from providing income statement and cash budget. Excel File Edit inser AutoSave OFF jane's Case study. 60
need to find balance sheet for june 30,2022 from providing income statement and cash budget.
Excel File Edit inser AutoSave OFF jane's Case study. 60 2 Home Review Insert Page Layout Tell me Draw Formulas Data Table View aber v Number X LE V Calibri (Body) 12 ' BIDE a. A v x fx =[@Aprill (@Mayl+@June] 10 000 Paste ilil IMI $ %) Conditional Formatting F16 G D E April 20980 12995 33975 24500 9475 May 0 51980 51980 38000 13980 June 0 77970 77970 57000 20970 F Total 20980 142945 163925 119500 44425 A B 1 Column1 Column2 2 Sales Revenue (Super) 3 Sales Revenue(Dj Fat) 4 Total Revenue 5 COGS 6 Gross profit 7 Expenses 8 Rent 9 Utilites 10 Advertising 11 Insurance 12 Salaries and Wages 13 Interest expenses 14 Depriciation 15 Total Expenses 16 Net Income 17 18 19 20 4000 170 679.5 200 6000 453 45 11548 -2073 4000 180 1040 200 6000 453 45 11918 2062 4000 210 1559 200 6000 453 45 12468 8502 12000 560 3278.5 600 18000 1360 135 35933.5 8492 B D olumni Column2 Column3 E Columns Column4 Cash Budget May 4175 Beginning Cash Balance April 0 June 45305.5 33975 Cash Receipts Cash Sales Financing Promotion Deposit Equity Investment Total Cash Reciepts 0 0 50,000 83,975 51980 0 0 0 56155 38985 12995 1500 0 53480 Total Cash available 83975 56155 98785.5 6000 4000 0 0 6000 4000 Cash Disbursements Operating Cost: Wage Expense Rent expense Insurance expense Lighting And display Racks Bikes Dividend Advertising Expense Utilites Expense Total Cash Disbursements 8 19 PO 21 22 23 24 25 26 0 6000 4000 2400 5400 129000 1000 O 0 147800 0 679.5 170 10849.5 1039.6 180 11219.6 27 Cash Balance Before Borrowing Additional Loan Cosing Cash Balance -63825 68000 4175 28 29 30 31 32 33 34 45305.5 0 45305.5 87565.9 0 87566 Step 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