In: Finance
Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $30,500 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $385,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $925,000 to his nephew Frodo. He can afford to save $3,400 per month for the next 10 years. If he can earn an EAR of 10 percent before he retires and an EAR of 7 percent after he retires, how much will he have to save each month in Years 11 through 30?
In: Finance
Shanken Corp. issued a 30 -year, 6 percent semiannual bond 4 years ago. The bond currently sells 95 percent of its face value. The book value of the debt issue $45 million. In addition the company has a second debt issue on the market, a zero coupon bond with 15 years left to maturity; the book value of this issue is 50 million and the bonds sell 54 percent of par. The company's tax rate is 40 percent. What is the company's total book value of debt? What is the company's total market value of debt? What is your best estimate of the aftertax cost of debt?
In: Finance
Problem 11-06 New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,000,000, and it would cost another $18,500 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $547,000. The machine would require an increase in net working capital (inventory) of $10,500. The sprayer would not change revenues, but it is expected to save the firm $391,000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 30%.
What is the Year 0 net cash flow? $
What are the net operating cash flows in Years 1, 2, and 3? Do not round intermediate calculations. Round your answers to the nearest dollar.
Year 1$ Year 2$ Year 3$
What is the additional Year 3 cash flow (i.e, the after-tax salvage and the return of working capital)? Do not round intermediate calculations. Round your answer to the nearest dollar. $
If the project's cost of capital is 12 %, what is the NPV of the project? Do not round intermediate calculations. Round your answer to the nearest dollar.
In: Finance
The comparative statements of Wildhorse Co. are presented
here.
|
WILDHORSE CO. |
||||
|---|---|---|---|---|
|
2022 |
2021 |
|||
|
Net sales |
$2,289,400 |
$2,135,000 |
||
|
Cost of goods sold |
1,267,000 |
1,247,440 |
||
|
Gross profit |
1,022,400 |
887,560 |
||
|
Selling and administrative expenses |
620,000 |
593,960 |
||
|
Income from operations |
402,400 |
293,600 |
||
|
Other expenses and losses |
||||
|
Interest expense |
27,280 |
24,800 |
||
|
Income before income taxes |
375,120 |
268,800 |
||
|
Income tax expense |
112,536 |
80,640 |
||
|
Net income |
$ 262,584 |
$ 188,160 |
||
|
WILDHORSE CO. |
||||
|---|---|---|---|---|
|
Assets |
2022 |
2021 |
||
|
Current assets |
||||
|
Cash |
$ 74,524 |
$ 79,608 |
||
|
Debt investments (short-term) |
91,760 |
62,000 |
||
|
Accounts receivable |
146,072 |
127,472 |
||
|
Inventory |
156,240 |
143,220 |
||
|
Total current assets |
468,596 |
412,300 |
||
|
Plant assets (net) |
804,760 |
645,172 |
||
|
Total assets |
$1,273,356 |
$1,057,472 |
||
|
Liabilities and Stockholders’ Equity |
||||
|
Current liabilities |
||||
|
Accounts payable |
$ 198,400 |
$180,296 |
||
|
Income taxes payable |
53,940 |
52,080 |
||
|
Total current liabilities |
252,340 |
232,376 |
||
|
Bonds payable |
272,800 |
248,000 |
||
|
Total liabilities |
525,140 |
480,376 |
||
|
Stockholders’ equity |
||||
|
Common stock ($5 par) |
359,600 |
372,000 |
||
|
Retained earnings |
388,616 |
205,096 |
||
|
Total stockholders’ equity |
748,216 |
577,096 |
||
|
Total liabilities and stockholders’ equity |
$1,273,356 |
$1,057,472 |
||
All sales were on account. Net cash provided by operating
activities for 2022 was $272,800. Capital expenditures were
$168,640, and cash dividends were $79,064.
Compute the following ratios for 2022. (Round all
answers to 2 decimal places, e.g. 1.83 or 1.83%.)
| (a) | Earnings per share | $ | |||
| (b) | Return on common stockholders’ equity | % | |||
| (c) | Return on assets | % | |||
| (d) | Current ratio | :1 | |||
| (e) | Accounts receivable turnover | times | |||
| (f) | Average collection period | days | |||
| (g) | Inventory turnover | times | |||
| (h) | Days in inventory | days | |||
| (i) | Times interest earned | times | |||
| (j) | Asset turnover | times | |||
| (k) | Debt to assets ratio | % | |||
| (l) | Free cash flow |
In: Finance
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2016, is shown here (millions of dollars):
Cash $ 3.5 Accounts payable $ 9.0
Receivables 26.0 Notes payable 18.0
Inventories 58.0 Line of credit 0
Total current assets $ 87.5 Accruals 8.5
Net fixed assets 35.0 Total current liabilities $ 35.5
Mortgage loan 6.0
Common stock 15.0
Retained earnings 66.0
Total assets $122.5 Total liabilities and equity $122.5
Sales for 2016 were $325 million and net income for the year was $9.75 million, so the firm's profit margin was 3.0%. Upton paid dividends of $3.9 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2017. Do not round intermediate calculations.
A. If sales are projected to increase by $100 million, or 30.77%, during 2017, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ million
B. Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places. %
C. Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Upton's profit margin and dividend payout ratio will be the same in 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets? (Hint: You don't need to forecast the income statements because the line of credit is taken out on last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2017 addition to retained earnings for the balance sheet without actually constructing a full income statement.) Round your answers to the nearest cent.
Upton Computers
Pro Forma Balance Sheet
December 31, 2017
(Millions of Dollars)
Cash $ ____
Receivables $ ___
Inventories $ ___
Total current assets $ ___
Net fixed assets $ ___
Total assets $ ___
Accounts payable $ ___
Notes payable $ ___
Line of credit $ ___
Accruals $ ___
Total current liabilities $ ___
Mortgage loan $ ___
Common stock $ ___
Retained earnings $ ___
Total liabilities and equity $ ___
In: Finance
Global Internet company is looking to expand their operations. They are evaluating their cost of capital based on various financing options. Investment bankers informed them that they can issue new debt in the form of bonds at a cost of 8%, and issue new preferred stocks for the price of $25 per share paying $2.5 dividends per share. Their common stock is currently selling for $20 per share and will pay a dividend of $1.5 per share next year. They expect a growth rate in dividends of 5% per year, and their marginal tax rate is 35%.
In: Finance
The TropicalFlowers Company is evaluating an asset that may increase sales by $120,000 every year for 4 years. There is no expected change in net operating working capital. The company's cost of capital is 6%. The proposed asset costs $400,000, will require $20,000 to modify for operations, and falls in the 3-year class MACRS for depreciation rates: .33, .45, .15, and .07 for years 1 through 4, respectively. At the end of the 4 years, it is expected that the asset may sell for $30,000. The company's tax rate is 21%. SHOW ALL WORK FOR FULL CREDIT.
a) What is the initial outlay for this project?
b) What are the operating cash flows in Years 1 through 4?
c) As part of the terminal cash flow in Year 4, what is the after-tax salvage value of the asset?
d) What is the net present value of this proposed asset investment? Should it be accepted or rejected?
In: Finance
In: Finance
In: Finance
Whitson Co. is looking for ways to shorten its cash conversion cycle. It has annual sales of $45,625,000, or $125,000 a day on a 365-day basis. The firm's cost of goods sold is 60% of sales. On average, the company has $7,500,000 in inventory, $5,750,000 in accounts receivable, and $2,750,000 in accounts payable. Its CFO has proposed new policies that would result in a 25% reduction in both average inventories and accounts receivable, and a 10% increase in average accounts payable. She also anticipates that these policies would reduce sales by 5%. What effect would these policies have on the company's cash conversion cycle?
Please Show Work
In: Finance
Suppose your firm is considering two mutually exclusive,
required projects with the cash flows shown below. The required
rate of return on projects of both of their risk class is 9
percent, and that the maximum allowable payback and discounted
payback statistic for the projects are 2 and 3 years,
respectively.
| Time: | 0 | 1 | 2 | 3 |
| Project A Cash Flow | -36,000 | 26,000 | 46,000 | 17,000 |
| Project B Cash Flow | -46,000 | 26,000 | 36,000 | 66,000 |
Use the discounted payback decision rule to evaluate these
projects; which one(s) should it be accepted or rejected?
accept both A and B
accept A, reject B
accept neither A nor B
reject A, accept B
In: Finance
Suppose your firm is considering two mutually exclusive,
required projects with the cash flows shown below. The required
rate of return on projects of both of their risk class is 9
percent, and that the maximum allowable payback and discounted
payback statistic for the projects are 2 and 3 years,
respectively.
| Time: | 0 | 1 | 2 | 3 |
| Project A Cash Flow | -21,000 | 11,000 | 31,000 | 2,000 |
| Project B Cash Flow | -31,000 | 11,000 | 21,000 | 51,000 |
Use the PI decision rule to evaluate these projects; accept the project with the higher PI value.
accept both A and B
accept A, reject B
accept neither A nor B
reject A, accept B
In: Finance
Suppose your firm is considering two mutually exclusive,
required projects with the cash flows shown below. The required
rate of return on projects of both of their risk class is 11
percent, and that the maximum allowable payback and discounted
payback statistic for the projects are 2 and 3 years,
respectively.
| Time: | 0 | 1 | 2 | 3 |
| Project A Cash Flow | -33,000 | 23,000 | 43,000 | 14,000 |
| Project B Cash Flow | -43,000 | 23,000 | 7,000 | 63,000 |
Use the payback decision rule to evaluate these projects; which
one(s) should it be accepted or rejected?
accept both A and B
reject A, accept B
accept A, reject B
accept neither A nor B
In: Finance
What is the difference between ‘fiduciary money’ and ‘fiat money?’
What happened to gold in 1933/1934 in the US?
In: Finance