Finance

User Generated

cuvyznffvatn

Business Finance

Description

Decide upon an initiative you want to implement that would increase sales over the next five years, (for example, market another product, corporate expansion, and so on).

Using the sample financial statements, create pro forma statements of five year projections that are clear, concise, and easy to read. Be sure to double check the calculations in your pro forma statements. Make assumptions that support each line item increase or decrease for your forecasted statements.

Discuss and interpret the financials in relation to the initiative. Make recommendations on potential discretionary financing needs.

Write a 350 - 700 word analysis of the company's short term and long term financing needs and determine strategies for the company to manage working capital.

xyz_p_and_l.pdf

_xyz_balance_sheet.pdf

Unformatted Attachment Preview

XYZ Company, INC. Balance Sheet For Year Ending December 31, 20XX ASSETS Current Assets Cash 10,525 Accounts Receivable 27,000 Inventory 30,000 2,000 Prepaid Expenses Total Current Assets 69,525 Fixed Assets 215,000 Property—net of depreciation 80,000 Equipment—net of depreciation 5,000 Vehicles—net of depreciation Total Fixed Assets 300,000 Total Assets 369,525 LIABILITIES Current Liabilities 20,000 Revolving lines of credit 5,000 Accounts Payable Current Portion of Long-term Debt Total Current Liabilities 15,000 40,000 Long-term Liabilities Long-term debt and capital leases 45,500 Loans payable to stockholders 60,500 Total Long-term Liabilities 106,000 Total Liabilities 146,000 Stockholders Equity 1,000 Common stock Additional Paid-in Capital 25,000 Retained Earnings (Cum from prior years) 53,190 Retained Earnings (From current P&L) 144,335 Total Stockholders Equity 223,525 Total Liabilities and Stockholders Equity 369,525 XYZ Company, INC. Profit and Loss Statement Year Ended December 31, 20XX % Sales Returns and allowances Net Sales 1,750,450 2,752 1,747,698 100.0 Cost of Sales Beginning Inventory Purchases Production Labor Ending Inventory Total Cost of Sales 50,000 610,162 420,108 30,000 1,050,270 60.1 Gross Profit 697,428 39.9 Selling Expense Wages Commissions Marketing Total Selling Expenses 75,000 25,000 25,000 125,000 7.2 Operating Expense Salaries Payroll taxes Benefits Office Supplies Postage Professional Fees Telephone Utilities Training & Education Miscellaneous Total Operating Expense 225,000 29,000 27,000 500 250 2,000 850 950 250 50 285,850 16.4 Operating Profit—EBITDA 286,578 16.4 Other Income (Expense) Interest Depreciation Amortization Total Other Income (Expense) (9,650) (12,000) (2,500) (24,150) Total Pre-tax Profit Income Tax Allowance 262,428 15.0 118,093 Net Profit 144,335 8.3 XYZ Company, INC. Profit and Loss Statement Year Ended December 31, 20XX % Sales Returns and allowances Net Sales 1,750,450 2,752 1,747,698 100.0 Cost of Sales Beginning Inventory Purchases Production Labor Ending Inventory Total Cost of Sales 50,000 610,162 420,108 30,000 1,050,270 60.1 Gross Profit 697,428 39.9 Selling Expense Wages Commissions Marketing Total Selling Expenses 75,000 25,000 25,000 125,000 7.2 Operating Expense Salaries Payroll taxes Benefits Office Supplies Postage Professional Fees Telephone Utilities Training & Education Miscellaneous Total Operating Expense 225,000 29,000 27,000 500 250 2,000 850 950 250 50 285,850 16.4 Operating Profit—EBITDA 286,578 16.4 Other Income (Expense) Interest Depreciation Amortization Total Other Income (Expense) (9,650) (12,000) (2,500) (24,150) Total Pre-tax Profit Income Tax Allowance 262,428 15.0 118,093 Net Profit 144,335 8.3 XYZ Company, INC. Balance Sheet For Year Ending December 31, 20XX ASSETS Current Assets Cash 10,525 Accounts Receivable 27,000 Inventory 30,000 2,000 Prepaid Expenses Total Current Assets 69,525 Fixed Assets 215,000 Property—net of depreciation 80,000 Equipment—net of depreciation 5,000 Vehicles—net of depreciation Total Fixed Assets 300,000 Total Assets 369,525 LIABILITIES Current Liabilities 20,000 Revolving lines of credit 5,000 Accounts Payable Current Portion of Long-term Debt Total Current Liabilities 15,000 40,000 Long-term Liabilities Long-term debt and capital leases 45,500 Loans payable to stockholders 60,500 Total Long-term Liabilities 106,000 Total Liabilities 146,000 Stockholders Equity 1,000 Common stock Additional Paid-in Capital 25,000 Retained Earnings (Cum from prior years) 53,190 Retained Earnings (From current P&L) 144,335 Total Stockholders Equity 223,525 Total Liabilities and Stockholders Equity 369,525
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags