ipl-logo

Underlying Assumptions In Exhibit B

947 Words4 Pages

In the DCF analysis shown in Exhibit B, multiple underlying assumptions must be made. First, the pro-forma for Robertson show in Exhibit 4 assumes a 6% sales growth rate per year, a conservative estimate as the industry is expecting 6-7% per year. The cost of goods sold (COGS) as a percentage of sales will gradually decrease from 69% in 2002 to 65% starting in 2006. Selling and administrative costs as a percentage of sales will decrease from 22% in 2002 to 19% starting in 2005 (Exhibit 4), and stabilize thereafter. Further assumptions in calculating the total free cash flows include that accounts receivable and accounts payable remain at the same percentage of sales as shown in 2002, 14.5% and 3.6% respectively, and that inventory stabilizes at 33% of sales starting in 2003. …show more content…

The underlying deductions here include the dividend growth rate remaining at 0% like it has for the past 5 years (Exhibit 1), and the future growth rate of Robertson having stabilized in 2007. This multiple of 12.42 is then multiplied to Robertson’s free cash flow in 2007, obtained by subtracting both capital expenditures and the increase in net working capital from its operating cash flow. The terminal value of $61,590,262 is added to its total free cash flows in 2007, and then discounted back 5 years using the WACC. Robertson’s net present value is $48,093,904, from which the $12,000,000 of net debt needs to be subtracted before the equity value of $36,093,904 is found. Since Robertson has 584,000 outstanding shares (Exhibit 1), the price per share using the DCF analysis is $61.80. This value is notably higher than the $50 per share Simmons is asking for, showing that the future value of Robertson is higher than the price Monmouth would current have to pay. To verify this, Vincent would benefit from

Show More
Related
1064 Words | 5 Pages

Thus, they are in a position to cover any debt obligations that may come up quickly. Their inventory turnover has been relatively steady over the five years of data. In year 7 their inventory turnover reached 3.2 which means inventory is moving through to customers at an increased rate over the year which correlates with their increased sales. This statement is supported by the fact that the days inventory held for stoves has dropped over the past five years from 146 days in year 3 to 114 days in year 7. These reductions have allowed for the reduction of their days in accounts payable from 51 all the way down to 11.

Read More
980 Words | 4 Pages

These could include equipment purchased with one formal amount and then continuing to collect a depreciation expense. After the store calculates the non-cash expenses, the managers must adjust the cash flow statement for the gains and losses on sales and assets. If the demand of an item were to decrease, the managers would need to take this into consideration. The store would then need to add back its losses as well as, subtract out the gains for the cash flow statement. While the managers need to add the non-cash expenses, they also need to account for changes in all non-cash assets.

Read More
1429 Words | 6 Pages

Gloria Panhorst HC 491 Week 7 Assignment Professor Mathur July 15, 2015 Chapter 13 1. Describe the relationship between profit and capital budget expenses. Capital budgeting is a step by step process that is used to determine the merits of investment opportunities. Deciding whether or not to accept an investment opportunity involves determining the investment rate of return that such a project will generate. (Gad 2012).

Read More
605 Words | 3 Pages

7.4 General Assumptions General Assumptions Year 1 2 3 Short Term Interest Rate 9.5% 9.5% 9.5% Long Term Interest Rate 10.0% 10.0% 10.0% Federal Tax Rate 33.0% 33.0% 33.0% Provincial Tax Rate 5.0% 5.0% 5.0% Personnel Taxes 15.0% 15.0% 15.0%   7.5 Profit and Loss Statements Proforma Profit and Loss (Yearly) Year 1 2 3 Sales $407,778 $440,400 $475,632 Cost of Goods Sold $40,778 $44,040 $47,563 Gross Margin 90.00% 90.00% 90.00% Operating Income $367,000 $396,360 $428,069 Expenses Payroll $198,500 $227,115 $257,268 General and Administrative $25,200 $26,208 $27,256 Marketing Expenses $2,039 $2,202 $2,378 Professional Fees and Licensure $5,219 $5,376 $5,537 Insurance Costs $1,987 $2,086 $2,191 Travel and Vehicle Costs $7,596 $8,356 $9,191 Rent and Utilities $20,000 $21,000 $22,050 Miscellaneous Costs $4,893 $5,285 $5,708 Payroll Taxes $29,775 $34,067 $38,590 Total Operating Costs $295,209 $331,695 $370,169 EBITDA $71,791 $64,666 $57,900 Federal Income Tax $23,691 $18,656 $16,642 Provincial Income Tax $3,590 $2,827 $2,522 Interest Expense $8,738 $8,131 $7,468 Depreciation Expenses $4,107 $4,107 $4,107 Net Profit $31,666 $30,944 $27,160 Profit Margin 7.77% 7.03%

Read More
1114 Words | 5 Pages

Exhibit 7, “CMG Growth Comparison”, shows that in terms of revenue

Read More
879 Words | 4 Pages

The first step is to create a set of base-case cash flow scenarios. After calculating cash flow, free cash flow of the company will be discounted in the valuation process. Moreover, the operating income will have two adjustments which are working capital adjustment and capital expenditures. The second step is to obtain the appropriate discount rate by determining cost of debt, cost of equity and weight average cost of capital. As for cost of debt, it is included cash and paid-in-kind (PIK) securities with floating interest rates based upon various base rates.

Read More
1152 Words | 5 Pages

By creating a cash budget, a company can predict when there could be a cash deficit and the magnitude of this deficit. In return, the budget shows that the difference between budget and actual value may need to be compensated by borrowing. Short-term financing may require purchasing inventory, promoting products or paying monthly fees. By forecasting cash demand, companies can assess future business opportunities based on the likely financing needs and cost components of the

Read More
921 Words | 4 Pages

Cost of equity was calculated using the 10 year UST rate, 5.02%, because it is a good measurement of the risk free rate, plus the firm’s beta, 0.56, multiplied by the risk premium, which we concluded to be 5%. This gave Blaine, when unlevered, a WACC of 7.82%. When taking the $40 million debt and $100 million cash buyout of stocks into account, cost of debt is now a factor. Cost of debt was 5.88%, the bond rating of a AAA rated company like we assume Blaine

Read More
597 Words | 3 Pages

The organization structure they use i. Who makes what decisions? d. Is the proportion of money from different products changing? e. How about return on investment? Profit margin? Other financial measures of interest (6) Projections for the

Read More
430 Words | 2 Pages

The cost of equity = r_E= r_f+ β*(R_Mkt-r_f) and the cost of debt = r_D= (Interest expense )/((Short term debt+Long term debt)/2),. E = 22.9 billion (Yahoo Finance, 2017) D = 23.3 billion (Morningstar, 2017) T_C = 38% or 0.38 (American Airlines Investor Relations, 2017) r_f= YTM = 0.91% (Yahoo Finance, 2017) r_E= r_f+ β*(R_Mkt-r_f) =

Read More
1141 Words | 5 Pages

Capital Budgeting: The growth of a company may be tied to the acquisition of new capital equipment, understanding the necessary cash outlays along with both the time value of money and useful life of the equipment are critical to be able to budget effectively and make sure that the company has the financial resources available when they need it. Capital budgeting also provides managers with data on the expected rate of inflation, the expected return on investment and the expected profitability on capital

Read More
1029 Words | 5 Pages

In order to make these calculations, your business must also consider discounted cash flow. ADD IMAGIN OF DCF You might have noticed a dilemma here. How does a startup use cash flow, when the financial history of earnings and expenses is not yet established? Perhaps more importantly, how to use the method when your startup is most likely losing money rather than making it?

Read More
1145 Words | 5 Pages

As you can see in Appendix 1 our analysis revealed that according to new cost accounting system the profitability of Regular model is about 90% whereas profits from selling Deluxe model is about 10%. In the meantime production costs of Regular model is about 45% and Deluxe model is 55%. Thus we may conclude that for Alice, Inc. it is not profitable to produce Deluxe model comparing to Regular model, as costs for production of Deluxe model are higher but the profit is lower.

Read More
1581 Words | 7 Pages

There are certain areas where still there is enough space for the improvements and processes can be more optimized. Few of the gaps that are identified while analyzing are discussed below: First, significantly reduced Days Sales Outstanding (DSO) can generate exemplified cash flow improvements in the financial supply chain management. Days Sales Outstanding (DSO) = (Accounts Receivable/Total Credit Sales) * Number of Days DSO, in general terms, means the average number of days it takes for company to collect revenue after the sale has been made.

Read More
1050 Words | 5 Pages

Now, Cost of equity (Re) = 8.95% + 1.21×7.43% = 17.94% While determining the cost of debt we again used 8.95%,30 year U.S. Government Interest Rate given in Table B as the risk free rate plus 1.10% debt rate premium above Government rate, which is given in Table A. Cost of debt (Rd) = 8.95% + 1.10% =

Read More

More about Underlying Assumptions In Exhibit B

Open Document