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

  Calculate future value of invested for 5years at annual rate

A)calculate the future value of $6,000, given that it will be invested for 5 years at an annual interest rate of 6 percent. B) recalculate part (a) using a compounding period that is semiannual (every 6 months).

  What is working capital management

What is working capital management and how does a company manage and measure liquidity?

  What is the expected return on the firms equity

What is the expected return on the firm's equity before the announcement of the stock repurchase plan and what is the value of equity after the announcement of the stock repurchase plan?

  Should accounting rules be changed to reflect capitalize

one of the advantages of leasing voiced in the past is that it kept its liabilities off the balance sheet, thus making it possible for a firm to obtain more leverage than it otherwise could have.

  What is the goal of common-size analysis

What does the financial analysis process reveal and what is the goal of common-size analysis

  How much can withdraw each month from the account

To do this, you will invest $830 a month in a stock account and $430 a month in a bond account. The return of the stock account is expected to be 10.3 percent, and the bond account will pay 6.3 percent.

  Organizational plan and business philosophy

Business decision, organizational plan, business philosophy, policy decision, or concept related to the class.

  Find the number of full payments needed

A debt of $4000 with interest at 12% compounded semi annually, is to be repaid by semi-annual payments of $400 each. Find the number of full payments needed and the final payment.

  What is the current price of the bond in the united states

Suppose a German company issues a bond with a par value of 1000, 15 years to maturity, and a coupon rate of 7.7 percent paid annually. If the yield to maturity is 8.8 percent, what is the current price of the bond

  What would be the market value of trident corporation

What would be the market value of Trident Corporation if it were unlevered and what would be the expected return on equity if Trident were an all-equity firm?

  What is the allocation rate if housekeeping services is used

The housekeeping departmenent at ricardo clinic, a multispecialty practice in Corpus christi had 152318.00 in direct cost during last year. These costs must be allocated to three revenue producing patient serices departments using the direct meth..

  What rate of return do expect to earn on the investment

The Yield To Maturity on a bond is the interest rate you earn on your investment if interest rates don't change. If you actually see the bond before it matures, your realized return is known as the holding period yield (HPY).

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