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

  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?

  Determine what is geometric return over the period

Your grandfather invested $1,000 in a stock 27 years ago. Currently the value of his account is $226,000. What is his geometric return over this period

  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..

  How to compute the required rate of return

Russo's Gas Distributor, Inc. wants to determine the required return on a stock with a beta coefficient of 0.5. Assuming the risk free rate of 6 percent and the market return of 12 percent.

  Determine what is the yield to maturity of the bond

A Japanese company has a bond outstanding that sells for 94 percent of its ?100,000 par value. The bond has a coupon rate of 5.30 percent paid annually and matures in 15 years.

  How long should owner wait to save the entire amount

A restaurant owner wants to buy new kitchen equipment for $25,000. He would like to pay for it through saving up $2,000 a week in a fund that pays 10% interest compounded monthly.

  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 much interest income will have to declare on tax return

You buy a zero coupon bond at the beginning of the year that has a face value of $1000, a YTM of 9 percent, and 12 years to maturity. You hold the bond for the entire year.

  What is the capital structure decision

What is the capital structure decision, how is the market value of a company affected by its capital structure?

  How much would the couples monthly savings be

A couple wants to renovate their house in 3 years. They need $27,000 which they plan to save for in monthly payments in an account that pays 8.5% compounded monthly. How much would their monthly savings be

  Discuss the factual rationale behind the nations decision

Discuss the factual rationale behind this nation's decision to go to war with Afghanistan and Iraq after the 9/11 attacks as well as the response from the international community

  Journalize the march transactions including explanations

the company uses these accounts: cash, prepaid insurance, land, building, equipment,accounts payable, unearned service revenue, common stock, retained earnings, dividends, service revenue, advertising expense and salaries and wage expense

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