USIL Company has developed a new detergent that can be sold for KES 350 per unit. The company has undertaken market research at a cost of KES 12 million in order to forecast the future cash flows of the investment project. The detergent is expected to continue gaining popularity for many years. The Chief Finance Officer has, however, proposed that investment in the new product should be evaluated over a four-year time-horizon, (even though sales would continue after the fourth year), on the grounds that cash flows after four years are too uncertain to be included in the evaluation. The variable and fixed costs (both in current price terms) are as follows:
Sales volume (units) |
Less than 1 million |
1 to 1.9 million |
2 to 2.9 million |
3 to 3.9 million |
Variable cost (KES per unit) |
250 |
270 |
280 |
300 |
Total fixed cost (KES) |
5 million |
5. 8 million |
6.8 million |
7.8 million |
The forecasted sales volumes are as follows:
Year |
1 |
2 |
3 |
4 |
Demand (units) |
700,000 |
1,200,000 |
1,600,000 |
2,200,000 |
The machinery required for production of the new detergent line would cost KES 200 million. An additional initial investment of KES 125 million will be needed for working capital. Plato Manufacturing Company pays corporate tax at the rate of 30% per year, payable one year in arrears. Selling price and cost information are in current price terms, before applying selling price inflation of 6% per year, variable cost inflation of 4 % per year and fixed cost inflation of 6% per year.
USIL Company uses an after-tax cost of capital of 14% to appraise all new capital projects. Assume that production lasts for only the four years under consideration above, calculate the NPV of investing in the new machine and advice if it’s financially acceptable (work to two decimal places).
In: Finance
Select a multinational company from the following industries:
Retail
Pharmaceutical
Computer Hardware
Manufacturing
Automotive
Review the selected company's most recent financial statements.
Calculate the following cash conversion cycle ratios based on the financial statements using Microsoft® Excel®:
Average inventory
Inventory turnover rate
Average account receivable
Account receivable turnover
Average collection cycle
In: Finance
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement Sales $ 748,000 Costs 583,000 Other expenses 19,000 Earnings before interest and taxes $ 146,000 Interest paid 15,000 Taxable income $ 131,000 Taxes (25%) 32,750 Net income $ 98,250 Dividends $ 29,475 Addition to retained earnings 68,775 CROSBY, INC. Balance Sheet as of December 31, 2017 Assets Liabilities and Owners’ Equity Current assets Current liabilities Cash $ 20,740 Accounts payable $ 54,900 Accounts receivable 43,680 Notes payable 14,100 Inventory 92,960 Total $ 69,000 Total $ 157,380 Long-term debt $ 131,000 Fixed assets Owners’ equity Net plant and equipment $ 424,000 Common stock and paid-in surplus $ 115,000 Retained earnings 266,380 Total $ 381,380 Total assets $ 581,380 Total liabilities and owners’ equity $ 581,380 In 2017, the firm operated at 75 percent of capacity. Construct the pro forma income statement and balance sheet for the company. Assume that fixed assets are sold so that the company has a 100 percent asset utilization. (Do not round intermediate calculations.)
In: Finance
Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year Unit Sales 1 73,800 2 79,200 3 84,600 4 82,100 5 68,700 Production of the implants will require $1,460,000 in net working capital to start and additional net working capital investments each year equal to 20 percent of the projected sales increase for the following year. Total fixed costs are $3,700,000 per year, variable production costs are $141 per unit, and the units are priced at $323 each. The equipment needed to begin production has an installed cost of $18,300,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifies as 7-year MACRS property. In five years, this equipment can be sold for about 25 percent of its acquisition cost. The company is in the 21 percent marginal tax bracket and has a required return on all its projects of 15 percent. MACRS schedule. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) What is the IRR of the project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
In: Finance
The Best Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated here. The corporate tax rate is 23 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. All net working capital is recovered at the end of the project. Year 0 Year 1 Year 2 Year 3 Year 4 Investment $ 28,100 Sales revenue $ 15,200 $ 16,800 $ 18,200 $ 14,700 Operating costs 3,800 3,550 6,000 4,600 Depreciation 7,025 7,025 7,025 7,025 Net working capital spending 390 290 405 240 ? a. Compute the incremental net income of the investment for each year. (Do not round intermediate calculations.) b. Compute the incremental cash flows of the investment for each year. (Do not round intermediate calculations. A negative amount should be indicated by a minus sign.) c. Suppose the appropriate discount rate is 10 percent. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
In: Finance
What are the three major types of mistakes made in the application of the DCF process, in real estate investment?
In: Finance
The Best Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated here. The corporate tax rate is 22 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. All net working capital is recovered at the end of the project. |
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | ||||||
Investment | $ | 26,500 | ||||||||
Sales revenue | $ | 13,600 | $ | 15,200 | $ | 16,600 | $ | 13,100 | ||
Operating costs | 3,000 | 3,150 | 4,400 | 3,000 | ||||||
Depreciation | 6,625 | 6,625 | 6,625 | 6,625 | ||||||
Net working capital spending | 310 | 210 | 245 | 160 | ? | |||||
a. |
Compute the incremental net income of the investment for each year. (Do not round intermediate calculations.) |
b. |
Compute the incremental cash flows of the investment for each year. (Do not round intermediate calculations. A negative amount should be indicated by a minus sign.) |
c. |
Suppose the appropriate discount rate is 10 percent. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
In: Finance
You will retire 20 years from now, and you think you will need an income of $6,000 per month for 20 years after you retire. You will begin saving for retirement by saving $700 per month for the next 10 years. How much will you have to save each month in the 10 years after that to have enough to meet your retirement goal? The interest rate is 9% APR. Round your answer to the nearest dollar.
In: Finance
Starset Machine Shop is considering a 4-year project to improve its production efficiency. Buying a new machine press for $430,000 is estimated to result in $172,000 in annual pretax cost savings. The press qualifies for 100 percent bonus depreciation, and it will have a salvage value at the end of the project of $71,000. The press also requires an initial investment in spare parts inventory of $29,000, along with an additional $3,550 in inventory for each succeeding year of the project. The shop’s tax rate is 24 percent and its discount rate is 11 percent. |
Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) |
In: Finance
You will retire 20 years from now, and you think you will need an income of $6,000 per month for 20 years after you retire.
You will begin saving for retirement by saving $700 per month for the next 10 years. How much will you have to save each month in the 10 years after that to have enough to meet your retirement goal?
The interest rate is 9% APR.
Round your answer to the nearest dollar.
In: Finance
Tara's lawyer gave her the following two options to settle her
invoice:
(a) $2,000.00 in 1 month and the balance of $2,100.00 in 3
months.
(b) Two equal payments, one in 37 days and the other in 5
months.
If money earned 2.50% p.a., what was the value of the equal
payments in Option (b) such that it is equivalent to the payments
in Option (a)? Use now as the focal date for this question.
Round to the nearest cent
In: Finance
$millions |
Sales |
Cost of Goods Sold |
Gross Profit |
Net Income |
Total Assets |
Total Liabilit. |
Stockholders’ Equity |
Target Corp |
73785 |
51997 |
21788 |
3363 |
40262 |
27305 |
12957 |
Nike Inc |
32376 |
17405 |
14971 |
3760 |
21396 |
9138 |
12258 |
Harley-Davidson |
5995 |
3620 |
2375 |
752 |
9991 |
8151 |
1840 |
Cisco System |
49247 |
18287 |
30960 |
10739 |
58067 |
58067 |
63585 |
a) Compute the following ratios for each company:
Gross Profit/ Sales |
Net Income/ Sales |
Net Income/ Stockholders’ Equity |
Liabilities/ Stockholders’ Equity |
|
Target Corp |
||||
Nike Inc |
||||
Harley-Davidson |
||||
Cisco System |
b) Comment on any differences among the companies’ gross profit-to-sale ratios and net income as a percentage of sales. Do differences in the companies’ business models explain the differences observed?
c) Which company reports the highest ratio of net income to equity? Suggest one or more reasons for this result.
d) Which company has financed itself with the highest percentage of liabilities to equity? Suggest one or more reasons for this result on such debt levels.
In: Finance
You have $100,000 in an account that earns 2% APR (Compounded
monthly)
You want to earn a higher rate of return and therefore are
considering two alternative investments. You will put your $100,000
in one of the two new accounts.
Investment 1 will pay you $860 per month for starting next month
120 months.
Investment 2 will pay you $2,600 per month for starting next month
40 months.
Which account should you choose and how much does it increase your
net worth?
Group of answer choices
Choose Investment 2 it increases your net worth by $528
Choose Investment 1 it increases your net worth by $544
Choose Investment 2 it increases your net worth by $508
Choose Investment 2 it increases your net worth by $547
In: Finance
Create the amortization schedule for a loan of $5,400, paid monthly over two years using an APR of 10 percent. Enter the data for the first three months.
|
In: Finance
Good evening can you please answer the following question, it is a foundation of corporate finance subject.
The Evans Corporation finds that it is necessary to determine
its marginal cost of capital. Evans’ current capital structure
calls for 30 percent debt, 10 percent preferred stock, and 60
percent common equity. Initially, common equity will be in the form
of retained earnings (Ke) and then new common stock (Kn). The costs
of the various sources of financing are as follows: debt, 5.6
percent; preferred stock, 11 percent; retained earnings, 8 percent;
and new common stock, 9.4 percent.
a. What is the initial weighted average cost of capital? (Include
debt, preferred stock, and common equity in the form of retained
earnings, Ke.) (Do not round intermediate calculations. Round the
final answer to 2 decimal places.)
Weighted average cost of capital 7.58 %
b. If the firm has $26 million in retained earnings, at what size
of investment will the firm run out of retained earnings? (Enter
the answer in millions. Round the final answer to 2 decimal
places.)
Capital structure size (X) $ 43.33 million
c. What will the marginal cost of capital be immediately after that
point? (Equity will remain at 60 percent of the capital structure,
but it will all be in the form of new common stock, Kn.) (Do not
round intermediate calculations. Round the final answer to 2
decimal places.)
Marginal cost of capital %
d. The 5.6 percent cost of debt referred to above applies only to
the first $42 million of debt. After that, the cost of debt will be
7.2 percent. At what size of investment will there be a change in
the cost of debt? (Enter the answer in millions. Round the final
answer to 2 decimal places.)
Capital structure size (Z) $ million
e. What will the marginal cost of capital be immediately after that
point? (Consider the facts in both parts c and d.) (Do not round
intermediate calculations. Round the final answer to 2 decimal
places.)
Marginal cost of capital %
In: Finance