Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Will you help in the following bolded sections. Please provide as much detail as possible. Thank you. Statement of Cash Flows Date Ending Date Ending
Will you help in the following bolded sections. Please provide as much detail as possible. Thank you.
Statement of Cash Flows | Date Ending | Date Ending | Date Ending | Date Ending | Date Ending |
20## | 20## | 20## | 20## | 20## | |
Cash Flows From (For) Operations | |||||
Net Income | $(109,585) | $23,313 | $69,538 | $167,837 | $205,088 |
Depreciation | 2,848 | 4,880 | 3,485 | 2,489 | 1,780 |
Changes in Current Assets | |||||
Accounts Receivable | (244,281) | (65,897) | (68,920) | (82,541) | (75,541) |
Inventory | (44,540) | (78,631) | 3,681 | (42,006) | 42,942 |
Changes in Current Liabilities | |||||
Accounts Payable | - | - | - | - | - |
Accrued Salaries and Wages | 73,449 | (73,449) | - | - | - |
Accrued Payroll Taxes and Benefits | - | - | - | - | - |
Cash From (For) Operating Activities | $(322,109) | $(189,783) | $7,785 | $45,780 | $174,269 |
Cash Flow (For) From Investing Activities | |||||
Fixed Asset Purchases | (69,142) | 27,142 | - | - | - |
Short Term Investments | - | - | - | - | - |
Long Term Investments | - | - | - | - | - |
Net Cash Flows (For) From Investing | $(69,142) | $27,142 | $- | $- | $- |
Cash Flow From (For) Financing Activities | |||||
Issuance of Common Stock | $- | $- | $- | $- | $- |
Short Term Debt Borrowings | - | - | - | ||
Long Term Debt Borrowings | - | - | - | - | - |
Short Term Debt Payments | - | - | - | - | |
Long Term Debt Payments | - | - | - | - | - |
Dividends Paid to Stockholders | - | - | - | - | - |
Cash Flows From (For) Financing | $- | $- | $- | $- | $- |
Net Change in Cash | $(391,251) | $(162,641) | $7,785 | $45,780 | $174,269 |
Beginning Cash Balance | $- | $(391,251) | $(553,892) | $(546,107) | $(500,327) |
Net Change in Cash | $(391,251) | $(162,641) | $7,785 | $45,780 | $174,269 |
Ending Cash Balance | $(391,251) | $(553,892) | $(546,107) | $(500,327) | $(326,059) |
Date Ending | Date Ending | Date Ending | Date Ending | Date Ending | Industry Average | |||||||
2021 | 2022 | 2023 | 2024 | 2025 | Ratios | |||||||
Liquidity Ratios | ||||||||||||
Current Ratio | ||||||||||||
Quick Ratio | ||||||||||||
Operating Cycle | ||||||||||||
Leverage Ratios | ||||||||||||
Debt/Equity | ||||||||||||
Times Interest Earned | ||||||||||||
Asset Management Ratios | ||||||||||||
Inventory Turnover | ||||||||||||
Receivables Turnover | ||||||||||||
Fixed Asset Turnover | ||||||||||||
Profitability Ratios | ||||||||||||
Gross Profit Margin | ||||||||||||
Operating Profit Margin | ||||||||||||
Return on Assets | ||||||||||||
DuPont Analysis | ||||||||||||
Net Profit Margin | ||||||||||||
Total Asset Turnover | ||||||||||||
Equity Multiplier | ||||||||||||
Return on Equity |
Pro Forma Income Statement | 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 | $295,353.29 | $376,883.94 | $464,457.58 | $548,492.58 | $644,133.61 | ||||
Gross Profit | $681,770 | $863,828 | $1,051,932 | $1,298,060 | $1,504,583 | ||||
General and Administrative Expenses | |||||||||
Salaries and Wages | $309,000.00 | $318,270.00 | $358,318.10 | $369,067.64 | $410,639.67 | ||||
Payroll Tax Expenses | |||||||||
Employee Benefits and Retirement | $131,692.00 | $131,692.00 | $149,189.00 | $149,189.00 | $166,686.00 | ||||
General Insurance Expense | $30,256.00 | $31,617.52 | $33,040.31 | $34,527.12 | $36,080.84 | ||||
Depreciation Expense | $2,847.76 | $4,880.46 | $3,485.47 | $2,489.05 | $1,779.60 | ||||
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,639.00 | $184,655.30 | $214,871.70 | ||||
Taxes & Licenses | $1,549.00 | $600.00 | $600.00 | $600.00 | $600.00 | ||||
Office Expense (MOH) (Desks, chairs, etc.) | $19,928.36 | ||||||||
Utilities expense | $10,168.21 | $10,168.21 | $10,168.21 | $10,168.21 | $10,168.21 | ||||
Equipment Purchase | $7,213.96 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
Outbound Transportation | $123,986.94 | $157,430.41 | $192,415.58 | $234,309.85 | $272,646.79 | ||||
Other - | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
Other - | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
Other - | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
Other - | $0.00 | $0.00 | $0.00 | $0.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 Expense14 | 15,000 | 15,000 | 15,000 | 15,000 | 15,000 | ||||
Earnings Before Taxes | $(109,585) | $28,098 | $96,077 | $256,054 | $334,111 | ||||
Income Tax Expense | - | 4,785 | 26,539 | 88,217 | 129,023 | ||||
Net Income (Loss) | $(109,585) | $23,313 | $69,538 | $167,837 | $205,088 | ||||
Statement of Retained Earnings (NOT REQUIRED FOR DRAFT OR BUSINESS PLAN) | |||||||||
Beginning Balance of Retained Earnings | $- | $(109,585) | $(86,272) | $(16,734) | |||||
Net Income (Loss) | (109,585) | 23,313 | 69,538 | 167,837 | 205,088 | ||||
Dividends to Stockholders | - | - | - | ||||||
Ending Retained Earnings | $(109,585) | $(86,272) | $(16,734) | $151,103 | $205,088 |
Pro Forma Balance Sheet | As of Inception | Date Ending | Date Ending | Date Ending | Date Ending | Date Ending | |||||
Date | 2022 | 2023 | 2024 | 2025 | 2026 | ||||||
ASSETS | |||||||||||
44540.087 | |||||||||||
Current Assets | |||||||||||
Cash and Cash Equivalents | $188,907 | $732,842.25 | $930,534.00 | $1,137,292.50 | $1,384,914.75 | $1,611,537.75 | |||||
Accounts Receivable | - | $244,280.75 | $310,178.00 | $379,097.50 | $461,638 | $537,179.25 | |||||
Inventory | - | 44,540 | 123,171 | 119,490 | 161,495 | 118,553 | |||||
Short Term Investments | - | - | |||||||||
Total Current Assets | $188,907 | $1,021,663 | $1,363,883 | $1,635,880 | $2,008,048 | $2,267,270 | |||||
Fixed (Long-Term) Assets | |||||||||||
Machinery and Equipment | $0.00 | $7,213.96 | - | - | - | - | |||||
Office Equipment | $0.00 | $19,928.36 | - | - | - | - | |||||
Rent Expense | $0 | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | |||||
Total Gross Fixed Assets | $- | $69,142.32 | $42,000 | $42,000 | $42,000 | $42,000 | |||||
Less: Accumulated Depreciation | - | -$3,878.64 | (6,647) | (4,747) | (3,390) | (2,424) | |||||
Net Fixed Assets | $- | $65,264 | $35,353 | $37,253 | $38,610 | $39,576 | |||||
Other Long Term Assets | |||||||||||
Long Term Investments | - | - | - | ||||||||
Intangibles, Net of Amortization | - | - | - | - | - | - | |||||
Total Other Long Term Assets | $- | $- | $- | $- | $- | $- | |||||
Total Assets | $188,907 | $1,086,927 | $1,399,235 | $1,673,132 | $2,046,658 | $2,306,846 | |||||
LIABILITIES AND STOCKHOLDERS' EQUITY | |||||||||||
Liabilities | |||||||||||
Current Liabilities | |||||||||||
Accounts Payable | - | - | |||||||||
Accrued Salaries and Wages | - | 73,449 | |||||||||
Accrued Payroll Taxes and Benefits | - | ||||||||||
Notes Payable | - | 80,960 | |||||||||
Current Maturity of LT Debt | |||||||||||
Total Current Liabilities | $154,409 | $- | $- | $- | $- | ||||||
Long-Term Liabilities | |||||||||||
LT Debt Less Current Maturities1 | $- | $- | $- | $- | $- | ||||||
Total Liabilities | $- | $154,409 | $- | $- | $- | $- | |||||
STOCKHOLDER'S EQUITY | |||||||||||
Common Stock | - | ||||||||||
Retained Earnings | 188,907 | $921,749.25 | |||||||||
Total Stockholders' Equity | $188,907 | $921,749 | $- | $- | $- | $- | |||||
Total Liabilities and Stockholders' Equity | $188,907 | $1,076,158 | $- | $- | $- | $- | |||||
1 Must adjust if Long Term Debt is used for Financing | |||||||||||
$(10,768) |
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