It is a few months before your store is opening. You expect to open the doors of your pretzel company as of January 1. You are starting fresh with no raw materials, no accounts receivable, and no accounts payable. You were able to secure several contracts with local businesses (i.e., sales associates that are paid on commission); based off these contracts, you were able to make projects for the first four months of the year.
Because your pretzels are made fresh daily, there is no work-in-process or finished goods inventory.
You plan to maintain a raw direct material inventory of 10% of the next month production.
Payment for raw direct materials is 25% in the month of purchase and 75% in the following months.
Your monthly sales projections are based off your last name, and sales are sold per dozen.
Quarterly sales projections:
Name January February March April
A-F 3750 3750 3750 3750
G-L 2750 3250 4000 5000
M-S 2000 3500 4500 5000
T-Z 1750 3750 3500 6000
Collections on Sales
Cash sales collected in the current month: 40%
Credit sales are collected in the following month: 60%
Financial Budget Information
Your initial investment in your business is $50,000, and you are looking to secure a bank loan for $50,000 with additional line of credit. However, you must always have a minimum cash end-of-month balance of $10,000.
If there is any cash over $10,000 available at the end of the month, you must repay your outstanding balance in $1,000 increments.
If the end-of-month cash balance falls below $10,000, you must make additional borrowing from the line of credit.
These borrowings are also in increments of $1,000.
Your bank loan and line of credit has an annual interest rate of 12% which is paid monthly on the total outstanding borrowings at the end of the prior month.
* Fixed asset acquisition in January is $90,000.
* Your income taxes are paid each quarter on net income at a rate of 25%.
1 Discuss the importance of beginning the master budget process with an accurate sales budget.
2 What are some important factors that a manager should consider when developing a sales budget? State why?
3 Distinguish between operating expenses and disbursements for operating expenses.
4 What is the main difference between the variable and absorption income statements?
5 What are the major benefits of budgeting?
The schedules needed to shown (click in cells to see computations). A few sentences respond to the theory questions asked.
Business Finance Applications
(See attached file for full problem description)
7.3 The Best Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated below. Cash flows are in $ thousands and the corporate tax rate is 34 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year.
1. Compute the incremental net income of the investment for each year.
2. Compute the incremental cash flows of the investment for each year.
3. Suppose the appropriate discount rate is 12 percent. What is the NPV of the project?
Year 0 Year 1 Year 2 Year 3 Year 4
Investment $10,000 ? ? ? ?
Sales revenue ? $7,000 $7,000 $7,000 $7,000
Operating costs ? 2,000 2,000 2,000 2,000
Depreciation ? 2,500 2,500 2,500 2,500
Net working capital (end of year) 200 250 300 200
7.12 A firm is considering an investment of $28 million (purchase price) in new equipment to replace old equipment with a book value of $12 million and a market value of $20 million. If the firm replaces the old equipment with the new equipment, it expects to save $17.5 million in operating costs the first year. The amount of these savings will grow at a rate of 12 percent per year for each of the following three years. The old equipment has a remaining life of four years. It is being depreciated by the straight-line method. 33.3 percent of the original book value of the new equipment will be depreciated in the first year, 39.9 percent will be depreciated in the second year, 14.8 percent will be depreciated in the third year, and 12.0 percent will be depreciated in the final year. The salvage value of both the old equipment and the new equipment at the end of four years is 0. In addition, replacement of the old equipment with the new equipment requires an immediate increase in net working capital of $5 million, which will not be recovered until the end of the four-year investment. Assume that the purchase and sale of equipment occurs today and all other cash flows occur at the end of their respective years. If the firm's cost of capital is 14 percent and is subject to a 40 percent tax rate, find:
1. The net investment.
2. The after-tax incremental cash flow at the end of each year.
3. The internal rate of return on the investment.
4. The net present value of the investment.
8.13 ? The Cornchopper Company is considering the purchase of a new harvester. Cornchopper has hired you to determine the break-even purchase price (in terms of present value) of the harvester. This break-even purchase price is the price at which the project's NPV is zero. Base your analysis on the following facts: The new harvester is not expected to affect revenues, but pretax operating expenses will be reduced by $10,000 per year for 10 years. and has been depreciated by the straight-line method.
? The old harvester can be sold for $20,000 today.
? The new harvester will be depreciated by the straight-line method over its 10-year life.
? The firm's required rate of return is 15 percent.
? The initial investment, the proceeds from selling the old harvester, and any resulting tax effects occur immediately.
? The corporate tax rate is 34 percent when they are realized.
? All other cash flows occur at year-end.
? The market value of each harvester at the end of its economic
12.3 The correlation between the returns on Ceramics Craftsman, Inc., and the returns on the S&P 500 is 0.675. The variance of the returns on Ceramics Craftsman, Inc., is 0.004225, and the variance of the returns on the S&P 500 is 0.001467. What is the beta of Ceramics Craftsman stock?
12.8 The following table lists possible rates of return on Compton Technology's stock and debt and on the market portfolio. The probability of each state is also listed.
State Probability Return on Stock (%) Return on Debt (%) Return on the Market (%)
1 0.1 3% 8% 5%
2 0.3 8 8 10
3 0.4 20 10 15
4 0.2 15 10 20
1. What is the beta of Compton Technology debt?
2. What is the beta of Compton Technology stock?
3. If the debt-to-equity ratio of Compton Technology is 0.5, what is the asset beta of Compton Technology? Assume no taxes.
29.1 The Lager Brewing Corporation has acquired the Philadelphia Pretzel Company in a vertical merger. Lager Brewing has issued $300,000 in new long-term debt to pay for its purchase. ($300,000 is the purchase price.) Construct the balance sheet for the new corporation if the merger is treated as a purchase for accounting purposes. The balance sheets shown here represent the assets of both firms at their true market values. Assume these market values are also the book values.
LAGER BREWING CORPORATION
(in $ thousands)
Current assets $ 400 Current liabilities $ 200
Other assets 100 Long-term debt 100
Net fixed assets 500 Equity 700
Total $1,000 Total $1,000
PHILADELPHIA PRETZEL COMPANY
(in $ thousands)
Current assets $ 80 Current liabilities $ 80
Other assets 40 Equity 120
Net fixed assets 80
Total $200 Total $200
29.4 Indicate whether you think the following claims regarding takeovers are true or false. In each case provide a brief explanation for your answer.
1. By merging competitors, takeovers have created monopolies that will raise product prices, reduce production, and harm consumers.
2. Managers act in their own interests at times and, in reality, may not be answerable to shareholders. Takeovers may reflect runaway management.
3. In an efficient market, takeovers would not occur because market price would reflect the true value of corporations. Thus, bidding firms would not be justified in paying premiums above market prices for target firms.
4. Traders and institutional investors, having extremely short time horizons, are influenced by their perceptions of what other market traders will be thinking of stock prospects and do not value takeovers based on fundamental factors. Thus, they will sell shares in target firms despite the true value of the firms.
5. Mergers are a way of avoiding taxes because they allow the acquiring firm to write up the value of the assets of the acquired firm.
6. Acquisitions analysis frequently focuses on the total value of the firms involved. An acquisition, however, will usually affect relative values of stocks and bonds, as well as their total value.