Short Note On Financial Projections

2. Use the projections provided in the case to compute the incremental cash flows for the PCB project. Provide a reasonable estimate for cash flows after 2009 as well.

Another concern identified, is the utilities expense budget for utilities in Year 9 which is $150,000. This amount is identified as a fixed amount and is unrelated to actually production activities and manufacturing efficiency. Considering that production levels and activity fluctuates throughout the year, the budget for utilities should be a variable item. An example; from Year 7 to Year 8, the utilities expenses increase by $15,000 and with this detection, ways to reduce this expense should be investigate. Another concern is a duplicated line item under the Selling, General, and Administrative Budget for Utilities and Utilities and Services. Another issue for concern, Total Variable Cost was reported to be lower; however was not enough for the lack of sales combined with an increase in advertising and transportation which resulted in an overall negative result. The low Net Sales directly impacted the Contribution Margin which decreased by $49,397. Overall, these concerns indicate the need for a flexible budget with variance analysis.

Mendel Paper Company has been doing relatively well with the sales of computer paper, napkins, place mats, and poster board. With more people eating out, the demand for napkins and place mats have increased. Computer paper and poster boards have slowly increased in demand as well. However, there is concern at the company with the fixed cost of operations. Marlene Herbert, the plant superintendent, said, “As we have automated our operation, we have experienced increases in fixed overhead and even variable overhead. And, we will have to add more equipment since it appears that we need even more plant capacity. We are operating over our normal capacity as it is.” (Case 2B). With the new production costs added in, will

The purpose of this case is to determine which key variables drive Crusty Pizza Restaurant’s monthly profit and then forecast what the monthly profit would be for potential stores. Based off of this information we will be able to make a recommendation to Crusty Dough Pizza Restaurant on which stores they should open and which they avoid. The group was provided 60 restaurants’ data that included monthly profit, student population, advertising expenditures, parking spots, population within 20 miles, pizza varieties, and competitors within 15 miles. For the potential stores we were given all of this

Customers come to this restaurant because of the good Italian food at a low price – you can get a meal for $7, including drinks. Customers also eat at Papa Geo’s due to the cleanliness of the facility, the speed of getting their seat and food, and the vending machines which keep the children busy while adults enjoy their meal.

In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.

Webmasters.com has developed a powerful new server that would be used for corporations’ Internet activities. It would cost $10 million at Year 0 to buy the equipment necessary to manufacture the server. The project would require net working capital at the beginning of each year in an amount equal to 10% of the year's projected sales; for example, NWC0 = 10%(Sales1). The servers would sell for $24,000 per unit, and Webmasters believes that variable costs would amount to $17,500 per unit. After Year 1, the sales price and variable costs will increase at the inflation rate of 3%. The company’s

The analysis of the financial projection in this report is based on the assumptions and the information which you (client) provided. These assumptions and information can be change with the passage of time. The

1. Tutti’s Sandwich Shop has the following information regarding costs at various levels of monthly sales. Help Tutti separate her costs into fixed costs and variable costs so that she can predict and evaluate costs at varying levels of guests served.

I have been asked to produce a report for management of Matteck plc in which I will evaluate the financial viability of the investment proposal. The company is considering expanding into Asia. This operation would involve the acquisition of a factory, a purchase of several new motor vehicles and a new distribution unit. The following are the estimated costs of the planned investment:

Market risk is the risk of potential loss in value of investment and other asset liability portfolios, including financial instruments, caused by changes in market variables, such as interest and currency exchange rates and equity and commodity prices. GE is exposed to market risk in the normal course of business operations as a result of ongoing investing and funding activities.

As an example, if fixed costs are $100, price per unit is $10, and variable costs per unit are $6, then the break-even quantity is 25 ($100 ÷ [$10 − $6] = $100 ÷$4). When 25 units are produced and sold, each of these units will not only have covered its own marginal (variable) costs, but will have also have contributed enough in total to have covered all associated fixed costs. Beyond these 25 units, all fixed costs have been paid, and each unit contributes to profits by the excess of price over variable costs, or the contribution margin. If demand is estimated to be at least 25 units, then the company will not experience a loss. Profits will grow with each unit demanded above this 25-unit break-even level.

As indicated by the case study S&P 500 index was use as a measure of the total return for the stock market. Our standard deviation of the total return was used as a one measure of the risk of an individual stock. Also betas for individual stocks are determined by simple linear regression. The variables were: total return for the stock as the dependent variable and independent variable is the total return for the stock. Since the descriptive statistics were a lot, only the necessary data was selected (below table.)

In the base case, we assumed 11.0% compounded annual growth rate. This is based on modest growth in domestic sales, and optimistic expectations for the international, Babies R Us, and online sales. Online sales can save relevant costs of physical display of products and associated costs of running a store. EBITDA margin is assumed higher and will be higher in the near future as the sales grow. Capital expenditure and depreciation amortization expenses are assumed fairly constant over the years . Overall operation will generate enough cash to support debt and interest payments. If Toys R Us would be able to specialize some of baby products, video games and

This paper will describe the differences between static and flexible budgets. Budgeting is a key component of financial management in any business. The most traditional form of budget is the static budget, which is one "that incorporates values about inputs and outputs that are conceived before the period in question begins" (Investopedia, 2012). This concept will be contrasted with a flexible budget. This technique allows for the values of inputs and outputs to be changed at any point, or at multiple points, during the period in question. The company would normally make such a change whenever it is realized that the change is needed. A new price from a supplier, for example, could be reflected immediately in a flexible budget, rather than at the end of the period. This and other differences between the two types of budget will be outlined in the course of this paper. The first section will explain the relationship between fixed and variable costs in a flexible budget. The second section will discuss the differences between static and flexible budgets. The third section will explain how flexible budgets can assist with cost-volume-profit (CVP) analysis.