Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have an accounting project and I have hit a bottleneck point in my understanding, in need of assistance please. Please answer A-O based on
I have an accounting project and I have hit a bottleneck point in my understanding, in need of assistance please.
Please answer A-O based on the given information from the following Statements given: The equations are listed above. Use the information from Income Statement, Balance Sheet, and Cash Flows statement to complete the ratios. Please be detailed in your description thank you in advance.
Ratios for the years 2021-2025 with industry average.
This is a Pro Forma Balance Sheet: Use as a guide.
Pro Forma Balance Sheet Input Field Build Formula As of Inception Data Ending Onto Ending Dain Ending Dain Ending Dain Ending 2023 2074 2026 ABEETS 10 11 Current Assets 12 Cash and Cash Equivalents 4 209,867 3901,762.00 3030,534.00 $1, 137 232.50 $1,384,914.75 14 $1,611,537.75 Accounts Receivable 5244 281.00 $310.178.00 $379,097.50 461,638 3537,179.25 15 Inventory 338,863 16 123, 171 119,490 161,456 118,553 Short Term Iminstmonks 17 Total Current Assets 4 1,484,906 $1,363,883 1,635,880 2,008 048 18 2.267,270 19 Fixed (Long-Term) Assets 20 Machinary and Equipment $7.213.06 Ofion Equipment $19.928.36 Rant Expanan $42,000.00 $42,000.00 $42,000.00 42,000.00 $42 000.00 Thirl Gross Fixed Assets 363. 142 32 42000 42.000 42.000 42.000 Less: Accumulated Onpreciation -$3, 878.64 (6,647) (4,747) (3,3001 (2,424] Not Fixed Assets 65 264 35,353 27 253 38.610 30.576 Other Long Tam Assets 30 Long Tom Imentments 31 Intangibles, Not of Amortization 32 Total Other Long Tar Assets 33 34 Total Assets $ 260 857 $ 1.550.170 31,309.235 1.673.132 2.046.858 2.306 848 LIABILITIES AND STOCKHOLDERS EQUITY 40 Liabilities Current Liabilities 44 Accounts Payable 456 ,279 45 Accrued Salaries and Wages 423,675 46 Accrued Payroll Thom and Benefits 131,602 47 Notes Payable 20,960 48 Currant Maturity of LT Debt 49 Total Current Liabilities $ 1,032,606 50 Long-Tam Lichilities LT Debt Less Current Maturities Total Liabiifan 5 1.092.608 56 STOCKHOLDER'S EQUITY 58 Common Stock Retained Eamings 209.857 61 $1.171.629.00 Total Stockholders' Equity $ 250,867 $ 1,171,629 62 $ 100.585 63 Total Liabilities and Stockholders' Equity. 8 264,857 5 2 264,235 66 67 8 714,024fx =X19*X39 B C D E F G H Pro Forma Income Statement Inpu Build Date Ending Date Ending Date Ending Date Ending Date Ending 2022 2023 2024 2025 2026 Sales Revenue $ 977,123 $1,240,712 $1,516,390 $1,846,553 $2,148,717 COGS 5295.353.20 5378,883.94 5484,457.58 5548,492.58 5644.133.81 Gross Profit $ 681,770 $ 863,828 $1,051,932 $1,298,060 $1,504.583 General and Administrative Expenses Salaries and Wages 5309,000.00 $318,270.00 5358,318.10 5369,067.64 5410,839.87 Payroll Tax Expenses Employee Benefits and Retirement $131,692.00 $131,602.00 $149. 189.00 $149, 189.00 $186,686.00 General Insurance Expense 530,256.00 531,817.52 $33,040.3 $34,527.12 536,080.84 Depreciation Expense $2.847.76 $4,880.46 $3, 485.47 $2.489.05 $1,779.80 Rent Expense $42,000.00 $42,000.00 $42,000.00 $42,000.00 $42,000.00 Advertising and Promotion Expense $97,712.30 $124,071.20 $151,839.00 $184,655.30 5214,871.70 Taxes & Licenses 51,549.00 5800.00 5800.00 $600.00 5800.00 Principle repayment Office Expense (MOH) (Desks, chairs, etc.) $19,928.36 Utilities expense $10.168.21 510, 168.21 $10, 188.21 $10, 168.21 $10, 188.21 Equipment Purchase $7,213.96 $0.00 $0.00 50.00 $0.00 Outbound Transportation 5123.986.94 57,430.41 5192,415.58 5234,309.85 $272.646.70 Other - $0.00 50.00 30.00 50.00 $0.00 Total General & Administrative Expenses $ 776,355 $ 820,730 $ 940,856 $1,027,006 $1,155,473 Earnings Before Interest and Taxes $ (94.585) $ 43,098 $ 111,077 $ 271,054 $ 349,111 Interest Expense 2.243 Earnings Before Taxes $ (96,828) $ 43,098 $ 111,077 $ 271,054 $ 349,111 Income Tax Expense 1,785 28,530 89,217 120,023 Net Income (Loss) $ (96,828) $ 38,313 $ 84,538 $ 182,837 $ 220,088 Statement of Retained Earnings (NOT REQUIRED FOR DRAFT OR BUSINESS PLAN) Beginning Balance of Retained Earnings $ $ (96,828) $ (58,515) $ 26,023 Net Income (Loss) (98.828) 38,313 84.538 182,837 220,088 Dividends to Stockholders Ending Retained Earnings $ (96,828) $ (58.515) $ 26,023 $ 208,860 $ 220.088Your Team Name Key Pro Forma Statement of Cash Flows Input Field Build Formula Date Ending Date Ending |Date Ending |Date Ending |Date Ending 2022 2023 2024 2025 2026 Cash Flows From (For) Operations Net Income $ 977.123 $ 38,313 $ 84,538 $ 182,837 $ 220,088 Depreciation 3.879 1.880 3.485 2.489 1,780 Changes in Current Assets Accounts Receivable 244.281 (85.897 (68,820 (82.541) (75.541) Inventory 338,863 215,802 3,681 (42,006) 42.942 Changes in Current Liabilities Accounts Payable 456.279 (456.270) Accrued Salaries and Wages 309.000) (423,675) Accrued Payroll Taxes and Benefits 131 692 (131.692) Cash From (For) Operating Activities $ 667.175 $ (818.657) $ 22,785 $ 60,780 $ 189.269 Cash Flow (For) From Investing Activities Fixed Asset Purchases (27.142) 27.142 Short Term Investments Long Term Investments Net Cash Flows (For) From Investing $ (27.142) $ 27.142 $ Cash Flow From (For) Financing Activities Issuance of Common Stock S S Short Term Debt Borrowings Long Term Debt Borrowings 80,960 Short Term Debt Payments Long Term Debt Payments Dividends Paid to Stockholders Cash Flows From (For) Financing 80,960 Net Change in Cash $ 720,993 $ 791.515) $ 22.785 $ 60.780 $ 189.269 Beginning Cash Balance S $ 720,993 $ (70,522) $ (47,737) $ 1 Net Change in Cash $ 720,993 $ (791.515) $ 22,785 $ 60,780 $ 189,269 Ending Cash Balance $ 720,993 $ (70.522) $ (47,737) $ 13,043 $ 202,312Teams Key 2 Fit-Mix Financial Ratios Table Input Field W Build Formula Assignments Date Ending Date Ending Date Ending Date Ending Date Ending Industry Average 2021 2022 2023 2024 2025 Ratios Calendar CO 9 Liquidity Ratios Calls 10 Current Ratio 11 Quick Ratio 1 12 Operating Cycle 17 Files 13 14 Leverage Ratios 15 Debt/Equity 16 Times Interest Earned 17 18 Asset Management Ratios 19 Inventory Turnover 180 20 Receivables Turnover 24 21 Fixed Asset Turnover I 22 23 Profitability Ratios 24 Gross Profit Margin 1 25 Operating Profit Margin 26 Return on Assets 27 28 DuPont Analysis 29 Net Profit Margin 70 30 Total Asset Turnover 31 Equity Multiplier 32 Return on EquityStep 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