Husky used annual observations from 20 prior years to estimate each of the four equations. Following are a definition of the variables used in the four equations and a statistical summary of these equations: St = Forecasted sales in dollars for Lockit in period t St–1 = Actual sales in dollars for Lockit in period t – 1 Gt = Forecasted U.S. gross domestic product in period t Gt–1 = Actual U.S. gross domestic product in period t – 1 Nt–1 = Lockit’s net income in period t – 1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are $1,500,000 in 2009, what would be the forecasted sales for Lockit in 2010?
MARRIOTT CORPORATION: THE COST OF CAPITAL Lodging Division Cost of Debt From Table A, * Fraction of Debt at Floating: 50% * Fraction of Debt at Fixed: 50% Using credit risk premium to calculate cost of debt, the equation is as follows: Cost of Debt = Low risk rate+Risk premium Floating Rate -- Assume the interest rate of floating rate debt changes every year so we use 1-year rate U.S. Government interest rate, which is 6.90% (from Table B). Therefore, the cost of floating rate debt equals 6.9% plus the 1.1% risk premium, which totaled to 8%. Fixed Rate -- As lodging assets have long useful lives, we use the long-term debt rate, i.e. 30-year U.S. Government interest rate, which is 8.95% (from Table B). Therefore, the cost of fixed rate debt equals 8.95% plus 1.1% risk premium, which totaled to 10.5% Cost of Debt = (0.5 x 0.08) + (0.5 x 0.105) = 0.095 = 9.25% [since floating rate and fixed rate debt both weigh 50%, we use the weighted average approach to calculate the total cost of debt rate] Based on historical data analysis below, we get an average income tax rate of 42%.
Margin of Safety (DOLLARS) Budgeted – break even = 100,000-62500= 37500 (Percentage) 37.500/100.000= 37.5% (Units) 37500/250= 150 3.Compute the company’s margin of safety in units assuming the proposal is accepted. Margin of Safety (Dollars) 137500-58929= 78571 (Units) 78571/275= 286 4. Compute the increase or decrease in profit assuming the proposal is accepted, show the contribution Income Statement for current and proposed. Present Proposed Sales 100,000 137500 Variable expense 64000 80000 CM 36000 57500 Fixed cost 22500 244750 Net income 13500 32750 difference: 19250 4a. What is the operating leverage for the current and proposed?
Stock Number Annual $ Volue J24 12,500 R26 9,000 L02 3,200 M12 1,550 P33 620 T72 65 S67 53 Q47 32 V20 30 What are the appropriate ABC groups of inventory items? (4 points) Stock Number Annual $ Volume % of Annual Volume % of Total Class: J24 12,500 46.21 79.48 A R26 9,000 33.27 L02 3,200 11.83 19.85 B M12 1,550 5.73 P33 620 2.29 T72 65 0.24 0.67 C S67 53 0.20 Q47 32 0.12 V20 30 0.11 Total Annual Volume 27,050 Problem 2: Assume you have a product with the following parameters: Holding cost per per unit Order per order What is the EOQ? What is the total cost for the inventory policy used? (4 points) Problem 3: Assume that our firm produces type C fire extinguishers. We make 30,000 of these fire extinguishers per year.
The present value of a four-year annuity due of $10,000 at a 6 percent annual rate is $36,700. The present value of a four-year annuity due of $10,000 at an 8 percent annual rate is $35,770. What liability should Ace report on its December 31, Year One, balance sheet? 1. $0 2.
In year 2 it reports a $40,000 loss. For year 3, it reports taxable income from operations of $100,000 before any loss carryovers. Using the corporate tax rate table, determine how much tax Willow Corp. will pay for year 3. Answer: $4,500. Description (1) Year 3 taxable income $100,000 (2) Year 1 NOL carryforward ($30,000) (3) Year 2 NOL carryforward ($40,000) (4) Taxable income reported 30,000 (1) - (2) -
FI 515 Homework week 2. 3-1 Days Sales Outstanding Days sales outstanding= receivables/ave sales per day= receivables/annual sales/365) 20 days x $20,000= $400,000 3-2 Debt Ratio Debt ratio formula=Debt ratio +equity ratio=1 Equity ratio = 1/EM….the equity multiplier is 2.5 1 / 2.5 = .40 equity ratio Debt ratio= debt ratio +equity ratio=1 1-equity ratio=debt ratio 1-.40=.60%=debt ratio 3-3 Market/Book Ratio Market value per share =$75 Common equity =6 billion Number of shares outstanding =800M Market value per share/ (common equity/# of shares outstanding)= market/book ratio $75/(6,000,000/800,000,000) = $75/7.5 10 billion= market to book ratio 3-4 PE Ratio Price per share/earnings per share= P/E Price per share/cash flow per share= Price/cash flow
Net initial investment outlay is $302,040. (Cost of new system + Installation) + (Proceeds from old equipment + Tax on proceeds + Removal cost) = Total cost + NCF (old) = 303,000 +-960 2. Tax depreciation savings = (36% tax rate) x (depreciation of each year) Depreciation for each year based on MACRS 5-year (Wikipedia) 3. Incremental cash flows = (Deprn. Tax savings + A.T. cost savings) each year [pic]2.
* $18 M purchase price * $1.8 M selling price * Investment in PPE (2007) was $16 M * Investment in PPE (2008) was $2 M * $4 M in Sales (2008) * $10 M in Sales (2009-2013) * COGS: 75% of Sales * SG&A: 5% of Sales * $2 M Operating Savings (2008) * $3.5 M Operating Savings (2009-2013) * Depreciation was on a straight-line basis for 6 years beginning in 2008 * $18 M / 6 years = $3 M * 40% tax rate * NWC: 10% of Sales * Salvage value was zero * The FCF per year was determined using the following: * Net Income + Depreciation Expense - ∆ Net Working Capital + Investment in PPE After generating the FCF for each year, I had to solve for NPV and IRR to value the investment. I calculated 2 NPVs—one using Excel’s NPV equation and the other by discounting each year’s FCF using the WACC I calculated earlier. Both methods gave me negative NPVs. * Excel NPV: ($489,344.33) * Discounted FCF NPV: ($538,153.89) Lastly, I used Excel to
FM421 – Applied Corporate Finance Case Study: Tottenham Hotspur plc 25th January 2013 201128545 201125438 201121479 201119785 201130179 201129057 1) Valuation based on Discounted Cash Flow In order to perform a DCF approach we first calculated the WACC and then the FCF. WACC WACC= rd(1-t)*[D/(D+E)] + re*[E/(D+E)] t = 35% (from the case, exhibit 1) rd= rf= 4.57% (exhibit 1, assuming β of debt = 0) Net Debt/EV=0.11 (EV = Market Value of Equity + Net Debt) re= rf+βe*(rm-rf)= 4.57%+ 1.29*5%=11.02 (under CAPM assumptions) [E/(D+E)]= 1-0.12=0.88 WACC= (0.0457)*(1-0.35)*0.11 + (0.1102)*0.89= 10.12% Free Cash Flow FCF= EBIT(1-t) – CAPEX – ΔNWC + Depreciation As EBIT and tax rate are given we have to calculate the ΔNWC. ΔNWC=Inventory + A/R – A/P As accounts receivable and payable are sensitive to sales changes, we assume that A/P and A/R change but their ratio to sales remains constant over time. We assume the same for the ratio of inventory/merchandise sales. (A/P)/Sales= 19.99/74.1 = 0.26977058 (A/R)/Sales= 64.4/74.1 = 0.869095816 Inventory/Merchandise sales= 1.17/5.2=0.225 We then multiplied the ratios for the equivalent factors (sales and merchandise sales) on the pro-forma balance sheet for the years between 2008 and 2020 and found the ΔNWC for every year.