Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 500 word analysis of the company's short term and long term financing needs and determine strategies for the company to manage working capital.

image text in transcribed 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 Propertynet of depreciation 80,000 Equipmentnet of depreciation 5,000 Vehiclesnet 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 ProfitEBITDA 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta

10th Canadian edition

1259261018, 1259261015, 978-1259024979

More Books

Students also viewed these Finance questions

Question

Identify potential fraud schemes related to long-lived assets.

Answered: 1 week ago