Create pro forma statements of five year projections

Assignment Help Financial Econometrics
Reference no: EM13327203

Create pro forma statements of five year projections that are clear, concise, and easy to read.XYZ Company, INC.Profit and Loss StatementYear Ended December 31, 20XX%Sales 1,750,450Returns and allowances 2,752Net Sales 1,747,698 100.0Cost of SalesBeginning Inventory 50,000Purchases 610,162Production Labor 420,108Ending Inventory 30,000Total Cost of Sales 1,050,270 60.1Gross Profit 697,428 39.9Selling ExpenseWages 75,000Commissions 25,000Marketing 25,000Total Selling Expenses 125,000 7.2Operating ExpenseSalaries 225,000Payroll taxes 29,000Benefits 27,000Office Supplies 500Postage 250Professional Fees 2,000Telephone 850Utilities 950Training & Education 250Miscellaneous 50Total Operating Expense 285,850 16.4Operating Profit-EBITDA 286,578 16.4Other Income (Expense)Interest (9,650)Depreciation (12,000)Amortization (2,500)Total Other Income (Expense) (24,150)Total Pre-tax Profit 262,428 15.0Income Tax Allowance 118,093Net 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

Prepaid Expenses 2,000

Total Current Assets 69,525

Fixed Assets

Property-net of depreciation 215,000

Equipment-net of depreciation 80,000

Vehicles-net of depreciation 5,000

Total Fixed Assets 300,000

Total Assets 369,525

LIABILITIES

Current Liabilities

Revolving lines of credit 20,000

Accounts Payable 5,000

Current Portion of Long-term Debt 15,000

Total Current Liabilities 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

Common stock 1,000

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

Reference no: EM13327203

Questions Cloud

What is the better gauge of our true cost of borrowing : When borrowing money, what is the better gauge of our true cost of borrowing - the nominal rate of interest or the real rate of interest? Please explain.
What is expansionary monetary policy : What is expansionary monetary policy? Why does expansionary monetary policy have an expansionary effect on the economy (that is, why does it cause aggregate demand to increase)? Please explain.
Given that monetary policy has only a long term effect on : Given that monetary policy has only a long term effect on an economy, central bankers should follow monetary rules rather than operate a more proactive policy approach as inflation targeting central banks currently do. Discuss.
What is the nash equilibrium in this case : For what values of X do both ? rms have a dominant strategy? What is the Nash equilibrium (or equilibria) in this case?
Create pro forma statements of five year projections : Create pro forma statements of five year projections that are clear, concise, and easy to read.XYZ Company, INC.Profit and Loss StatementYear Ended December 31, 20XX%Sales 1,750,450Returns and allowances 2,752Net Sales
Describe what happened to the price of the bond : Suppose you purchased one of these bonds at par value when it was issued. Right away, market interest rates jumped, and the YTM on your bond rose to 6%. What happened to the price of your bond
How much did consumtion decline when homes fell by : If every $1,000 increase in the real price of homes adds 5 cents to annual consumer spending, by how much did consumtion decline when homes fell by $ 2 trillion?
Determine what is the reason for difference in the yields : Alongside, plot your choice of yields of bonds from a publicly traded organization, for the same time periods. * Compare the two yield curves and answer the following questions: Which yield curve is higher
What advantages are there, if any to noncompetitive markets : Under what conditions might gov’t intervention improve market outcome in a perfectly competitive industry? Discuss.

Reviews

Write a Review

Financial Econometrics Questions & Answers

  A project report on banking system

The objective of this business report is to focus upon evaluating the current portfolio of Baituna home loans product of Bank Muscat and its volumes. It focus upon the current standing of the product in Oman and its performance on the basis of its vo..

  Questions on financial econometrics

Objective and multiple choice questions on Financial Econometrics responsible for creating financial statements.

  Option valuation report

Value Joseph's option position based on Black-Scholes method and analysis needs cover details behind the standard Black - Scholes method and explain detailed adjustment made to the standard BS method

  Conduct a bivariate nonlinear conintegration tests

Conduct a bivariate nonlinear conintegration tests using threshold Vector Error Correction (TVEC) methodology. Need to develop Matlab code.

  Calculate the expected exchange rate

Use a properly labelled IS-LM graph to analyze and illustrate the effect and calculate the expected exchange rate for the end of the year.

  Capm and capital structure

Reflect on the papers. Synthesize the key points they're making and consider the challenges of such points in a given context within your environment.

  Calculate the npv-irr and non-discounted payback period

Calculate the NPV, IRR, and Non-Discounted Payback Period using Excel - Outline and write the essay starting with the evidence-supported defense of your points and slowly transition into an address of opposing points.

  Objectives and principles guiding corporate governance

What is corporate governance and what are the objectives and principles guiding corporate governance?

  What is the capital budgeting process

What is capital budgeting, what is the capital budgeting process, what are the principles of capital budgeting and when do we make a capital investment?

  How do taxes affect the cost of capital

What is the cost of capital, what are WACC and MCC and how do taxes affect the cost of capital?

  How do you create or decrease leverage

What is leverage, how do you create or decrease leverage and why is leverage used?

  Calculate the wacc for both investment

Outline and write the essay starting with the evidence-supported defense of your points and slowly transition into an address of opposing points - Calculate the WACC for both investment. Calculate the NPV for investments discounted at their respec..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd