For PROF.STAN ONLY

profilerisele
copy_of_pro-forma_statement_template.xlsx
Home>Business & Finance homework help>Accounting homework help>For PROF.STAN ONLY

Base Data

XYZ Company, INC. XYZ Company, INC.
Profit and Loss Statement Balance Sheet
Year Ended December 31, 20XX Year Ended December 31, 20XX
Year 0 % of Net Sales Assets
Sales 1,750,450 Current Assets
Less: Returns & allowances 2,752 Cash 10,525
Net Sales 1,747,698 100.00% Accounts Receivables 27,000
Inventory 30,000
Cost of Sales Prepaid Expenses 2,000
Beginning Inventory 50,000 2.86% Total Current Assets 69,525
Purchases 610,162 34.91%
Production Labor 420,108 24.04% Fixed Assets
Ending Inventory 30,000 1.72% Property - net depreciation 215,000
Total Cost of Sales 1,050,270 60.09% Equipment - net depreciaiton 80,000
Vehicles - net depreciation 5,000
Gross Profit 697,428 39.91% Total Fixed Assets 300,000
Selling Expense Total Assets 369,525
Wages 75,000 4.29%
Commissions 25,000 1.43% Liabilities
Marketing 25,000 1.43% Current Liabilities
Total Selling Expenses 125,000 7.15% Revolving lines of credit 20,000
Accounts Payable 5,000
Operating Expenses Current Portion of Long-term debt 15,000
Salaries 225,000 12.87% Total Current Liabilities 40,000
Payroll taxes 29,000 1.66%
Benefits 27,000 1.54%
Office Supplies 500 0.03% Long term Liabilities
Postage 250 0.01% Long-term debt and capital leases 45,500
Professional Fees 2,000 0.11% Loans payable to stockholders 60,500
Telephone 850 0.05% Total long-term liabilities 106,000
Utilities 950 0.05%
Training & Education 250 0.01% Total Liabilities 146,000
Miscellaneous 50 0.00%
Total Operating Expenses 285,850 16.36% Stockholders Equity
Common Stock 1,000
Operating Profit 286,578 16.40% Additional Paid-in Capital 25,000
Retained Earnings (Cum from prior years) 53,190
Other Income (Expense) Retained Earnings (From current P&L) 144,335
Interest (9,650) (0.55%) Total Stockholders Equity 223,525
Depreciation (12,000) (0.69%)
Ammortization (2,500) (0.14%) Total Liabilities and Stockholders Equity 369,525
Total Other Income (Expense) (24,150) (1.38%)
Pre-Tax Profit 262,428 15.02%
Income Tax Allowance 118,093 6.76%
Net Profit 144,335 8.26%

Pro-forma Income Statement

XYZ Company, INC.
Pro -forma Profit and Loss Statement
Year 0 Year 1 Year 2 Year 3
Sales 1,750,450.0 - 0 - 0 - 0
Less: Returns & allowances 2,752.0 - 0 - 0 - 0
Net Sales 1,747,698.0 - 0 - 0 - 0
Cost of Sales
Beginning Inventory 50,000.0 30,000.0 - 0 - 0
Purchases 610,162.0 - 0 - 0 - 0
Production Labor 420,108.0 - 0 - 0 - 0
Ending Inventory 30,000.0 - 0 - 0 - 0
Total Cost of Sales 1,050,270.0 - 0 - 0 - 0
Gross Profit 697,428.0 - 0 - 0 - 0
Selling Expense
Wages 75,000.0 - 0 - 0 - 0
Commissions 25,000.0 - 0 - 0 - 0
Marketing 25,000.0 - 0 - 0 - 0
Total Selling Expenses 125,000.0 - 0 - 0 - 0
Operating Expenses
Salaries 225,000.0 - 0 - 0 - 0
Payroll taxes 29,000.0 - 0 - 0 - 0
Benefits 27,000.0 - 0 - 0 - 0
Office Supplies 500.0 - 0 - 0
Postage 250.0 - 0 - 0 - 0
Professional Fees 2,000.0 - 0 - 0 - 0
Telephone 850.0 - 0 - 0 - 0
Utilities 950.0 - 0 - 0 - 0
Training & Education 250.0 - 0 - 0 - 0
Miscellaneous 50.0 - 0 - 0 - 0
Total Operating Expenses 285,850.0 - 0 - 0 - 0
Operating Profit 286,578.0 - 0 - 0 - 0
Other Income (Expense)
Interest (9,650) 0 0 0
Depreciation (12,000) 0 0 0
Ammortization (2,500) 0 0 0
Total Other Income (Expense) (24,150) 0 0 0
Pre-Tax Profit 262,428.0 - 0 - 0 - 0
Income Tax Allowance 118,093.0 - 0 - 0 - 0
Net Profit 144,335.0 - 0 - 0 - 0

Pro-forma Balance Sheet

XYZ Company, INC.
Pro -forma Balance Sheet
Year 0 Year 1 Year 2 Year 3
Assets
Current Assets
Cash 10,525 - 0 - 0 - 0
Accounts Receivables 27,000 - 0 - 0 - 0
Inventory 30,000 - 0 - 0 - 0
Prepaid Expenses 2,000 - 0 - 0 - 0
Total Current Assets 69,525 - 0 - 0 - 0
Fixed Assets
Property - net depreciation 215,000 - 0 - 0 - 0
Equipment - net depreciaiton 80,000 - 0 - 0 - 0
Vehicles - net depreciation 5,000 - 0 - 0 - 0
Total Fixed Assets 300,000 - 0 - 0 - 0
Total Assets 369,525 - 0 - 0 - 0
Liabilities
Current Liabilities
Revolving lines of credit 20,000 - 0 - 0 - 0
Accounts Payable 5,000 - 0 - 0 - 0
Current Portion of Long-term debt 15,000 - 0 - 0 - 0
Total Current Liabilities 40,000 - 0 - 0 - 0
Long term Liabilities
Long-term debt and capital leases 45,500 - 0 - 0 - 0
Loans payable to stockholders 60,500 - 0 - 0 - 0
Total long-term liabilities 106,000 - 0 - 0 - 0
Total Liabilities 146,000 - 0 - 0 - 0
Stockholders Equity
Common Stock 1,000 - 0 - 0 - 0
Additional Paid-in Capital 25,000 - 0 - 0 - 0
Retained Earnings (Cum from prior years) 53,190 197,525.0 197,525.0 197,525.0
Retained Earnings (From current P&L) 144,335 - 0 - 0 - 0
Total Stockholders Equity 223,525 197,525 197,525 197,525
Total Liabilities and Stockholders Equity 369,525 197,525 197,525 197,525
External Financing - 0 (197,525) (197,525) (197,525)
Total Liabilities & Stockholders Equity including External Financing 369,525 - 0 - 0 - 0

Working Capital Forecast

Net Working Capital Forecast
Ratios
Year 0 Year 1 Year 2 Year 3 Assets Year 0 Year 1 Year 2 Year 3
Inventory Turnover 58.3 0.0 0.0 0.0 Cash 10525 0 0 0.0
Accounts Receivables Turnover 64.7 0 0 0 Accounts Receivables 27000 0.0 0.0 0.0
Accounts Payable 122.03 0 0 0 Inventory 30000 0 0.0 0.0
Assets to Sales Ratio 0.21 0.00 0.00 0.00 Prepaid Expenses 2000 0 0 0.00
Gross Profit Margin 39.9% 0.00% 0.00% 0.00% Total Current Assets 69,525.0 - 0 - 0 - 0
Operating Margin 16.4% 0.0% 0.0% 0.0%
Net Profit Margin 8.3% 0.0% 0.0% 0.0% Liabilties
Revolving Line of Credit 20000 0
Income Tax Rate 45% Accounts Payable 5,000.00 - 0
Total Current Liabilities 25,000.0 - 0
Net Working Capital 44,525.0 -0
Capital Structure Increase in Working Capital (44,525.0)
Common Stock 26000 17.1%
Revolving Line of Credit 20000 13.2%
Long term Loans + Debt 106000 69.7%