need u to write issue and explanation a budget balanced sheet as of june 30.
The company's balance sheet as od March 31 is given belon: sctainine at least 350.000 in wach. Regutred Propare a maser budget foe the three-nunih periost enting June 30 . Inclate the following detalled schedule: I. a. A sales tralger, by mowh and in weal. b. A whofule of expected cash culloctions, by month and in tatal. c. A merchandise punctuses trafget in units atat in dollers. Shos the bedget hy poouh asal in total 3. A budgeted iacone stitement for the three-iateith perind ending June 30, Use the centribution appooach. 4. A budgeted bolance shoct as af June 90 fourance is paid on an annual bous, in Nincmber of each year. in the firs mosth of the folluwing guaster. Earrings Unlimited Balance Sheet June 30 Assets Cash Accounts receivable Inventory $500,000[($100000010%)+($50000080%)] Prepaid insurance $48,000[12000 units $40] Property, plant \& equipment, net $12,000 [\$21000 - \$9000] Blank. $964,000[$950000$42000+$56000] Blank Total assets Blank Ulabilitles \& Stockholders' Equity Accounts payable $84,000[$16800050%] Dividends payable $15,000 [Declared in June but payable in July] Common stock/shares $800,000 [Continues from previous balance sheet] Retained earnings $719,700 [\$580000 + \$154700 - \$15000] Blank Blank \begin{tabular}{l} Blank \\ Total Uabilities 8. Stockholders' Equity $1,618,700 \\ \hline \end{tabular} - Report should include: - Cover page with all team members' names and decide on a name for your team, also the name of the Company and the title of your report (based on the project) - Table of Contents - The narrative as given in the project o Issues and explanations, definitions, charts, formula, etc. as part of your answers - Example: definition of operating leverage - Your calculation of operating leverage based on company information - Interpretation of your results (what does your answer indicate) The company's balance sheet as od March 31 is given belon: sctainine at least 350.000 in wach. Regutred Propare a maser budget foe the three-nunih periost enting June 30 . Inclate the following detalled schedule: I. a. A sales tralger, by mowh and in weal. b. A whofule of expected cash culloctions, by month and in tatal. c. A merchandise punctuses trafget in units atat in dollers. Shos the bedget hy poouh asal in total 3. A budgeted iacone stitement for the three-iateith perind ending June 30, Use the centribution appooach. 4. A budgeted bolance shoct as af June 90 fourance is paid on an annual bous, in Nincmber of each year. in the firs mosth of the folluwing guaster. Earrings Unlimited Balance Sheet June 30 Assets Cash Accounts receivable Inventory $500,000[($100000010%)+($50000080%)] Prepaid insurance $48,000[12000 units $40] Property, plant \& equipment, net $12,000 [\$21000 - \$9000] Blank. $964,000[$950000$42000+$56000] Blank Total assets Blank Ulabilitles \& Stockholders' Equity Accounts payable $84,000[$16800050%] Dividends payable $15,000 [Declared in June but payable in July] Common stock/shares $800,000 [Continues from previous balance sheet] Retained earnings $719,700 [\$580000 + \$154700 - \$15000] Blank Blank \begin{tabular}{l} Blank \\ Total Uabilities 8. Stockholders' Equity $1,618,700 \\ \hline \end{tabular} - Report should include: - Cover page with all team members' names and decide on a name for your team, also the name of the Company and the title of your report (based on the project) - Table of Contents - The narrative as given in the project o Issues and explanations, definitions, charts, formula, etc. as part of your answers - Example: definition of operating leverage - Your calculation of operating leverage based on company information - Interpretation of your results (what does your answer indicate)
