Assume that sales will grow at 5.00%. The following accounts (cash, accounts receivable, inventory, net fixed assets, accounts payable and accruals, as well as operating costs) are assumed to change with sales and will maintain their current percentage of sales rates into 2016. The dividend payout ratio will remain the same. Long-term debt and notes payable will remain constant into 2016 as will interest expense, as a result. The firm also does not plan to issue any additional common stock or conduct any share repurchases. The firm’s tax rate is 40%. Any additional funds needed will be sourced through a line-of-credit (LOC) and surpluses will be paid out through a special dividend.
2015 | |
---|---|
Sales | $1,445.00 |
Operating Costs: | $1,245.00 |
EBIT | $200.00 |
Interest | $35.00 |
Earnings Before Taxes | $165.00 |
Taxes (40%) | $66.00 |
Net Income | $99.00 |
Dividends | $49.50 |
Addition to Retained Earnings | $49.50 |
BALANCE SHEET AS OF 12/31/2015:
ASSETS | 2015 |
---|---|
Cash | $72.25 |
Accounts Receivable | $144.50 |
Inventory | $289.00 |
Current Assets | $505.75 |
Net Fixed Assets (Net PPE) | $361.25 |
Total Assets (TA) | $867.00 |
LIABILITIES & SHAREHOLDER EQUITY | 2015 |
---|---|
Accounts Payable and Accruals | $36.13 |
Notes Payable | $40.00 |
Current Liabilities | $76.13 |
Long Term Debt | $310.00 |
Total Liabilities | $386.13 |
Common Stock | $300.00 |
Retained Earnings | $180.88 |
Owners' Equity | $480.88 |
Total Liabilities and Shareholder Equity | $867.00 |
In the following questions, determine the percentage-of-sale forecast factors:
Accounts Payable & Accruals: | |
Operating Costs: | |
Cash: | |
Accounts Receivable: | |
Inventory: | |
Net Fixed Assets (NFA): |
In: Finance
Describe how, by use of the capital asset pricing model, you
might select a suitable
risk discount rate to use in profitability measurement.
(This will be a presentation question, please guide thoroughly. Thank you!)
In: Finance
Describe the advantages and disadvantages to existing shareholders of funding expansion using convertible loan stock.
(This will be a presentation question, please guide thoroughly. Thank you!)
In: Finance
Dorsey Company manufactures three products from a common input in a joint processing operation. Joint processing costs up to the split-off point total $350,000 per quarter. For financial reporting purposes, the company allocates these costs to the joint products on the basis of their relative sales value at the split-off point. Unit selling prices and total output at the split-off point are as follows: Product Selling Price Quarterly Output A $ 16 per pound 15,000 pounds B $ 8 per pound 20,000 pounds C $ 25 per gallon 4,000 gallons Each product can be processed further after the split-off point. Additional processing requires no special facilities. The additional processing costs (per quarter) and unit selling prices after further processing are given below: Product Additional Processing Costs Selling Price A $ 63,000 $ 20 per pound B $ 80,000 $ 13 per pound C $ 36,000 $ 32 per gallon Required: 1. What is the financial advantage (disadvantage) of further processing each of the three products beyond the split-off point? 2. Based on your analysis in requirement 1, which product or products should be sold at the split-off point and which product or products should be processed further?
In: Finance
In: Finance
Find the present value of payments of $250 every six months starting immediately and continuing through 6 years from the present, and $200 every six months thereafter through 12 years from the present. if i^(2) = 4%.
In: Finance
An automobile manufacturer is considering one of two systems for its windshield assembly line. The first is a robotic system that should save money due to a reduction in labor and material cost. This robotic system will cost $400,000. Current practice is to recover this cost over the first two years. One full-time technician and one full-time material handler will be needed with this system. The full-time technician costs $60,000 per year and the material handler costs $52,000 per year.
If the company selects the manual system, it will need four full-time material handlers at a cost of $52,000 each per year. If the manual system is selected, the company will incur additional costs of $0.50 per windshield installed. (Hint: This is the savings referred to in the first paragraph.)
Q.1) Suppose that the company is going to produce 9,000 windshields per month. How much would the robotic design have to save per unit in order for the company to be indifferent between the two design options?
Q.2) For the manual design and with the current price of $9.50 per unit, the marketing group has said that there is a demand for 8,000 units per month. However, if the company were to drop the price by $0.25 per unit and adopt the robotic design, the demand would increase to 9,000 units per month. The other information for the robotic design is provided in a) above. Looking at these two options, which strategy should the company adopt? All of the other information provided in part a) applies in this analysis. Show your work supporting your decision.
In: Finance
If I asked you to determine the optimal portfolio for a client, what information would you need? Once that information is provided, what optimization problem would you solve to identify the optimal portfolio (what are you going to maximize or minimize)? What constraints would you place on this problem?
In: Finance
Mr. Agirich of Aggie Farms is thinking about investing in a new Double LL four-row potato harvester. He is currently operating two two-row harvesters and the new harvester would replace both of the current potato harvesters. Mr. Agirich expects that he will save $29,000 a year by eliminating one tractor and one operator. He also expects the new harvester to not bruise the potatoes as much as the old harvesters. The potato processor has agreed to pay a $0.11/sack premium for the reduction in bruising. Mr. Agirich operates 1,500 acres of potatoes and averages 350 sacks to the acre. Mr. Agirich contracts all of his acreage with the processor (so calculate the revenue from the premium on the total acreage). The cost of the new potato harvester is $165,000. Mr. Agirich plans on keeping the harvester for 3 years and he thinks he can sell it for $65,000 at the end of 3 years. To maintain the efficiency of the harvester, Double LL has offered to replace all bearings and chains on the harvester for $22,000 a year starting in year two. Mr. Agirich requires at least a 14% return on capital. IRS will allow to depreciate over 7 years and assume that the salvage is 0. The marginal Tax rate is 25%.
In: Finance
Your company is considering the development of an electric bicycle. The development will take four years and cost $100,000 per year. Once developed, the company expects to generate a positive cash flor of $150,000 per year for ten years. The cost of capital is 10%; assume all cash flows occur at the end of each year. What is the Net Present Value of the electric bicycle? Should the company invest in this product?
In: Finance
You are considering investing in a very risky new venture. The owner wants you to invest $150,000 today, and has promised that you will receive $1,000,000 in 10 years. Because of the high risk of this investment, your required rate of return is 20%. What is the Net Present Value of this investment?
In: Finance
Discounted Cash Flows
A. choose between a perpetuity of $45,000/year inflating at 2%/year and a lump sum payment of $1,255,000. Use a 5.5% discount rate. Use the box to explain your choice.
B. run NPVs and IRRs for three airplane fuel pumps. Use a 12% discount rate: Pump A costs $35,000 and saves the firm $5,000 each year for years 1-15 Pump B costs $35,000 and saves the firm $4,500 each year for ever Pump C costs $35,000 and saves $4,000 in year 1; this saving continues for ever, increasing 4% per year
C. provide a 25% guaranteed cash flow IRR to an airline flying to your airport. The airline's cash flows are minus $1 million at the start and positive $371,739 each year for years 1-4. Calculate the subsidy to be paid at the start. Explain your answer in the box provided.
D. calculate the implicit interest rate (IRR) of a computer lease. The computers cost $30,000 at the start and pay a yearly lease of $12,000 for years 1-3. The salvage value is $1,000 at the end of year 4. Explain your answer in the box provided. If the firm can borrow at 8.5% from the bank, should it borrow from the bank or lease?
In: Finance
35. Nonconstant Growth Storico Co. just paid a dividend of $3.35 per share. The company will increase its dividend by 16 percent next year and will then reduce its dividend growth rate by 4 percentage points per year until it reaches the industry average of 4 percent dividend growth, after which the company will keep a constant growth rate forever. If the required return on the company’s stock is 10.5 percent, what will a share of stock sell for today?
I am trying to set up a table on MS Excel to use as a calculator for this problem. I would prefer each individual calculation within the equation explained to me with the proper cells. Thank you!
In: Finance
Assume that interest rate parity holds and will continue to hold in the future. At the beginning of the month, the spot rate of the British pound is $1.60 while the 1-year forward rate is $1.50. Assume that U.S. annual interest rate remains steady over the month. At the end of the month, the one-year forward rate of the British pound exhibits a discount of 1%. Explain how the British annual interest rate changed over the month, and whether it is higher, lower, or equal to the U.S. rate at the end of the month.
In: Finance
Explain why there are differences and discrepancies in the recommendations of the four selection criteria. ( NPV , IRR , Pay back period and Profitability Index )
In: Finance