|
Dahlia Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for the next fiscal year. Sales are projected to grow by 10 percent to $330 million. Current assets, fixed assets, and short-term debt are 15 percent, 75 percent, and 5 percent of sales, respectively. Charming Florist pays out 30 percent of its net income in dividends. The company currently has $131 million of long-term debt and $59 million in common stock par value. The profit margin is 10 percent. |
| a. |
Construct the current balance sheet for the firm using the projected sales figure. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| b. |
Based on Ms. Colby’s sales growth forecast, how much does Charming Florist need in external funds for the upcoming fiscal year? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| c-1. |
Construct the firm’s pro forma balance sheet for the next fiscal year. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
| c-2. |
Calculate the external funds needed. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to the nearest whole dollar amount, e.g., 1,234,567.) |
In: Finance
| The Optical Scam Company has forecast a sales growth of 25 percent for next year. The current financial statements are shown here: |
| Income Statement | ||||
| Sales | $ | 32,100,000 | ||
| Costs | 26,512,400 | |||
| Taxable income | $ | 5,587,600 | ||
| Taxes | 1,955,660 | |||
| Net income | $ | 3,631,940 | ||
| Dividends | $ | 1,452,776 | ||
| Addition to retained earnings | 2,179,164 | |||
| Balance Sheet | |||||||
| Assets | Liabilities and Owners' Equity | ||||||
| Current assets | $ | 7,370,000 | Short-term debt | $ | 7,383,000 | ||
| Long-term debt | 5,162,750 | ||||||
| Fixed assets | 18,952,000 | ||||||
| Common stock | $ | 1,707,250 | |||||
| Accumulated retained earnings | 12,069,000 | ||||||
| Total equity | $ | 13,776,250 | |||||
| Total assets | $ | 26,322,000 | Total liabilities and equity | $ | 26,322,000 | ||
| a. |
Using the equation from the chapter, calculate the external financing needed for next year. (Do not round intermediate calculations and round your answer to the nearest whole dollar amount, e.g., 32.) |
| b-1. |
Construct the firm’s pro forma balance sheet for next year. (Do not round intermediate calculations and round your answers to the nearest whole dollar amount, e.g., 32.) |
| b-2. |
Calculate external financing needed. (Do not round intermediate calculations and round your answer to the nearest whole dollar amount, e.g., 32.) |
| c. |
Calculate the sustainable growth rate for the company based on the current financial statements. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
In: Finance
|
The most recent financial statements for Bello, Inc., are shown here: |
| Income Statement | Balance Sheet | ||||||||||
| Sales | $ | 39,600 | Assets | $ | 145,000 | Debt | $ | 42,000 | |||
| Costs | 27,000 | Equity | 103,000 | ||||||||
| Taxable income | $ | 12,600 | Total | $ | 145,000 | Total | $ | 145,000 | |||
| Taxes (25%) | 3,150 | ||||||||||
| Net income | $ | 9,450 | |||||||||
|
Assets and costs are proportional to sales; debt and equity are not. A dividend of $3,300 was paid, and the company wishes to maintain a constant payout ratio. Next year’s sales are projected to be $45,144. |
|
What is the external financing needed? |
In: Finance
Last year Janet purchased a $1,000 face value corporate bond with an 9% annual coupon rate and a 25-year maturity. At the time of the purchase, it had an expected yield to maturity of 10.24%. If Janet sold the bond today for $1,051.86, what rate of return would she have earned for the past year? Do not round intermediate calculations. Round your answer to two decimal places.
In: Finance
| The most recent financial statements for Hailey Co. are shown here: |
| Income Statement | Balance Sheet | ||||||||||
| Sales | $ | 78,600 | Current assets | $ | 32,100 | Long-term debt | $ | 69,200 | |||
| Costs | 27,000 | Fixed assets | 128,500 | Equity | 91,400 | ||||||
| Taxable income | $ | 51,600 | Total | $ | 160,600 | Total | $ | 160,600 | |||
| Taxes (22%) | 11,352 | ||||||||||
| Net income | $ | 40,248 | |||||||||
|
Assets and costs are proportional to sales. The company maintains a constant 25 percent dividend payout ratio and a constant debt-equity ratio. |
|
What is the maximum increase in sales that can be sustained assuming no new equity is issued? |
In: Finance
An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would cost $240.41 million, and the expected cash inflows would be $80 million per year for 5 years. If the firm does invest in mitigation, the annual inflows would be $84.88 million. Unemployment in the area where the plant would be built is high, and the plant would provide about 350 good jobs. The risk adjusted WACC is 16%.
Calculate the NPV and IRR with mitigation. Round your answers to
two decimal places. Enter your answer for NPV in millions. Do not
round your intermediate calculations. For example, an answer of
$10,550,000 should be entered as 10.55. Negative value should be
indicated by a minus sign.
NPV $ million
IRR %
Calculate the NPV and IRR without mitigation. Round your answers
to two decimal places. Enter your answer for NPV in millions. Do
not round your intermediate calculations. For example, an answer of
$10,550,000 should be entered as 10.55.
NPV $ million
IRR %
In: Finance
A project has an initial requirement of $190,151 for new equipment and $11,289 for net working capital. The installation costs are expected to be $15,824. The fixed assets will be depreciated to a zero book value over the 4-year life of the project and have an estimated salvage value of $77,787. All of the net working capital will be recouped at the end of the project. The annual operating cash flow is $78,979 and the cost of capital is 14% What is the project's NPV if the tax rate is 28%?
In: Finance
Determine the value at the end of five years of a $6,000 investment (today) in a bank certificate of deposit (CD) that pays a nominal annual interest rate of 10 percent, compounded under either of the following three terms. Round your answers to the nearest cent.
Semiannually
$
Quarterly
$
Monthly
$
In: Finance
A)
You are expecting to receive $300 at the end of each year in years 3, 4, and 5, and then 500 each year at the end of each year in years 10 through 25, inclusive. If the appropriate discount rate is 9.2 percent, for how much would you be able to sell your claim to these cash flows today?
B)
You are paying an effective annual rate of 12.93 percent on your credit card. The interest is compounded monthly. What is the annual percentage rate on your account? (Enter rate in percents, not in decimals.)
C)
If you put up $43,463 today in exchange for a 10.7 percent, 12 year annuity, what will the annual cash flow be?
In: Finance
What is financial management? How does financial management differ in the sport industry as compared to other industries? What are key economic factors that influence the sport industry? (400-500 words)
In: Finance
During the past five years, you owned two stocks that had the following annual rates of return:
| Year | Stock T | Stock B | ||
| 1 | 0.17 | 0.10 | ||
| 2 | 0.06 | 0.02 | ||
| 3 | -0.06 | -0.12 | ||
| 4 | -0.04 | 0.04 | ||
| 5 | 0.11 | 0.06 | ||
Stock T: %
Stock B: %
Which stock is most desirable by this measure?-Select-Stock TStock BItem 3 is more desirable because the arithmetic mean annual rate of return is -Select-higherlowerItem 4 .
Stock T: %
Stock B: %
By this measure, which is the preferable stock?-Select-Stock TStock BItem 7 is the preferable stock.
Stock T:
Stock B:
By this relative measure of risk, which stock is preferable?-Select-Stock TStock BItem 10 is the preferable stock.
Stock T: %
Stock B: %
In: Finance
Discuss the pros and cons of tax-backed and revenue municipal bonds and the advantages and disadvantages of including them in a portfolio.
In: Finance
Debit Credit
| Cash | $157,100 | |
| accounts receivable | 52,000 | |
| interest receivable | 21,400 | |
| notes receivable (due in 90 days) | 171,500 | |
| office supplies | 16,000 | |
| automobiles | 173,000 | |
| accumulated depreciation-automobile | $85,000 | |
| equipment | 138,000 | |
| accumulated depreciation-equipment | 25,000 | |
| land | 85,000 | |
| accounts payable | 96,000 | |
| interest payable | 40,000 | |
| salaries payable | 17,000 | |
| unearned fees | 30,000 | |
| long term notes payable | 154,000 | |
| common stock | 25,580 | |
| retained earnings | 230,220 | |
| dividends | 45,000 | |
| fees earned | 554,000 | |
| interest earned | 36,000 | |
| interest earned | 27,000 | |
| depreciation expense-automobiles | 18,500 | |
| depreciation expense-equipment | 183,000 | |
| salaries expense | 45,000 | |
| wages expense | 34,000 | |
| interest expense | 35,600 | |
| office supplies expense | 64,500 | |
| advertising expense | 26,200 | |
| repairs expense-automobiles |
| totals | $1,292,800 | $1,292,800 |
Requried
1 A_ prepare the income statement for the year ended December 31,2017?
2.B- prepare the statement of retained earnings for the year ended December 31,2017?
3. C- prepare Chiara company's balance sheet as of December 31,2017?
In: Finance
| Some recent financial statements for Smolira Golf Corp. follow. |
| SMOLIRA GOLF CORP. 2017 and 2018 Balance Sheets |
||||||||||||||||
| Assets | Liabilities and Owners’ Equity | |||||||||||||||
| 2017 | 2018 | 2017 | 2018 | |||||||||||||
| Current assets | Current liabilities | |||||||||||||||
| Cash | $ | 35,485 | $ | 38,848 | Accounts payable | $ | 38,612 | $ | 43,132 | |||||||
| Accounts receivable | 18,351 | 28,756 | Notes payable | 20,108 | 17,025 | |||||||||||
| Inventory | 3,940 | 43,072 | Other | 20,854 | 25,514 | |||||||||||
| Total | $ | 57,776 | $ | 110,676 | Total | $ | 79,574 | $ | 85,671 | |||||||
| Long-term debt | $ | 120,500 | $ | 184,214 | ||||||||||||
| Owners’ equity | ||||||||||||||||
| Common stock and paid-in surplus | $ | 56,100 | $ | 56,100 | ||||||||||||
| Accumulated retained earnings | 267,072 | 305,974 | ||||||||||||||
| Fixed assets | ||||||||||||||||
| Net plant and equipment | $ | 465,470 | $ | 521,283 | Total | $ | 323,172 | $ | 362,074 | |||||||
| Total assets | $ | 523,246 | $ | 631,959 | Total liabilities and owners’ equity | $ | 523,246 | $ | 631,959 | |||||||
| SMOLIRA GOLF CORP. 2018 Income Statement |
|||||||
| Sales | $ | 511,954 | |||||
| Cost of goods sold | 363,178 | ||||||
| Depreciation | 45,838 | ||||||
| Earnings before interest and taxes | $ | 102,938 | |||||
| Interest paid | 20,783 | ||||||
| Taxable income | $ | 82,155 | |||||
| Taxes (21%) | 17,253 | ||||||
| Net income | $ | 64,902 | |||||
| Dividends | $ | 26,000 | |||||
| Retained earnings | 38,902 | ||||||
|
Prepare the 2018 statement of cash flows for Smolira Golf Corp. (Negative answers should be indicated by a minus sign.) |
| SMOLIRA GOLF CORP. | |
| STATEMENT OF CASH FLOWS | |
| FOR 2018 | |
| Cash, beginning of the year | |
| Operating Activities | |
| Net income | 45838 |
| Add: Depreciation | |
| Add: Increase in accounts payable | |
| Add: Increase in other current liabilities | |
| Less: Increase in accounts receivable | |
| Less: Increase in inventory | |
| Net cash from operating activities | |
| Investment activities | |
| Fixed asset acquisition | |
| Net cash from investment activities | |
| Financing activities | |
| Dividend paid | |
| Decrease in notes payable | |
| Increase in long-term debt | |
| Net cash from financing activities | |
| Net increase in cash | |
| Cash, end of year | |
In: Finance
The Holtzman Corporation has assets of $444,000, current
liabilities of $51,000, and long-term liabilities of $71,000. There
is $35,500 in preferred stock outstanding; 20,000 shares of common
stock have been issued.
a. Compute book value (net worth) per share.
(Round your answer to 2 decimal places.)
b. If there is $25,700 in earnings available to
common stockholders, and Holtzman’s stock has a P/E of 19 times
earnings per share, what is the current price of the stock?
(Do not round intermediate calculations. Round your final
answer to 2 decimal places.)
c. What is the ratio of market value per share to
book value per share? (Do not round intermediate
calculations. Round your final answer to 2 decimal places.)
In: Finance