Purchase Solution

Forecasting Balance Sheet and Income Statements

Not what you're looking for?

Ask Custom Question

XieCorp is a pc solutions provider that is looking to expand its operations. Currently it has $500K (K=thousand) to invest in an upgrade in facilities. The goal is the hire additional staff to acquire new customers. Last year 20XX XieCorp made $13M (M=million) in total revenues. Their expenses were 65% of revenue and they were taxed at a rate of 16%.

CEO, Jonathan DoeMan wants to finance $1.5M over 5 years for the expansion of the company which cost $2M. He has been informed the cost of money for this financing is 6.2%. This expansion will result in an increase in annual revenue of $850K per year in years 1-3 and an increase of 1.4M per year in years 4-6.

Mr. DoeMan also wants to invest 50% of the company's annual profit in a money market account which assumes a rate of 8% compounded semi-annually.

Requirements

Assume XieCorps revenue will continue at the level provided, create a basic income statement showing the impact of the additional revenue along with the additional expenses listed above by year over a 5 year period. Showing net income/profit for each year.

Purchase this Solution
Solution Summary

Given the assumptions and requirements of the problem, the required balance sheets and income statements are provided in Excel spreadsheet and .pdf formats. A brief explanation is given for how the figure in each line the financial statements is calculated.

Solution Preview

I have prepared an Excel spreadsheet with the required income statement. In case you don't have Excel, I have also posted the spreadsheet in pdf format.

Notice that the numbers are in Thousands of dollars. (This is to reduce the number of zeros). I've put the equations used ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Probability Quiz

Some questions on probability

View More Free Quizzes
Related BrainMass Solutions

  • Pro Forma Financial Statements and Free Cash Flow Computation

    612182 Pro Forma Financial Statements and Free Cash Flow Computation FORECASTING PRO FORMA FINANCIAL STATEMENTS Prepare a pro forma income statement and balance sheet for Webb Enterprises, found in Problem 6-7, where revenues are expected to grow

  • Forecasting: Percentage of sales method.

    Percentage of Sales Method of Forecasting The Percentage of Sales Method of forecasting is based on the idea that most Balance Sheet and Income Statement Accounts vary with variations in the sales level.

  • Preparing forecasted financial statements

    Use an interest rate of 13%, and assume that any new debt will be added at the end of the yea (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income.

  • Pro-Forma Forecasting OF Urban Outfitters Financial Statements.

    448264 Pro-Forma Forecasting OF Urban Outfitters Financial Statements. For part of my assignment for my MBA, We had to prepare the consolidated financial statements (Balance sheets, income statements and cashflows).

  • Financial Planning: Short Term and Long Term

    136355 Financial Planning: Short Term and Long Term Attached is an income statement and balance sheet results for 2004 (for a company that began operations in 2003) and need help forecasting for the next year as sales are expected to increase by 50% in

  • Proforma Statements, Forecasting, Capital Intensity

    statement method merely projects an expected increase in activity over every account, whether income statement or balance sheet, equally.

  • Financial Forecasting

    There are three sections in a financial plan i) the Starting Balance Sheet, ii) the Pro-Forma (or Forecast) Income Statement, and iii) the Cash Flow Forecast.

  • profitability ratios

    ROA Net income can be found on the Income statements of the respective companies Total Assets can be found on the Balance sheet 2.ROE EQ can be found on the Balance sheet 3.

  • sources of financing for photography business

    ., angel financing) -Preparing pro-forma financial statements for lenders (e.g., Balance Sheet and Income Statement) -Describe methods of forecasting the future financial needs of the enterprise -Evaluate a set of assumptions regarding investment

  • External funding needed

    C) Plug number =-$32 External funding needed =-$32 Plug number (variable) = External funding needed Word document contains EFN equation,pro-forma income statements and balance sheets Tthe plug number which makes pro-forma balance sheet balance is clearly

View More Related Solutions