Questions
Dahlia Colby, CFO of Charming Florist Ltd., has created the firm’s pro forma balance sheet for...

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...

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...

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...

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...

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...

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%.

  1. 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  %

  2. How should the environmental effects be dealt with when evaluating this project?
    1. The environmental effects should be ignored since the plant is legal without mitigation.
    2. The environmental effects should be treated as a sunk cost and therefore ignored.
    3. If the utility mitigates for the environmental effects, the project is not acceptable. However, before the company chooses to do the project without mitigation, it needs to make sure that any costs of "ill will" for not mitigating for the environmental effects have been considered in the original analysis.
    4. The environmental effects should be treated as a remote possibility and should only be considered at the time in which they actually occur.
    5. The environmental effects if not mitigated would result in additional cash flows. Therefore, since the plant is legal without mitigation, there are no benefits to performing a "no mitigation" analysis.
  3. Should this project be undertaken?
    1. The project should be undertaken only under the "mitigation" assumption.
    2. The project should be undertaken since the IRR is positive under both the "mitigation" and "no mitigation" assumptions.
    3. The project should be undertaken since the NPV is positive under both the "mitigation" and "no mitigation" assumptions.
    4. Even when no mitigation is considered the project has a negative NPV, so it should not be undertaken.
    5. The project should be undertaken only if they do not mitigate for the environmental effects. However, they want to make sure that they've done the analysis properly due to any "ill will" and additional "costs" that might result from undertaking the project without concern for the environmental impacts.

In: Finance

A project has an initial requirement of $190,151 for new equipment and $11,289 for net working...

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...

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.

  1. Semiannually
    $  

  2. Quarterly
    $  

  3. Monthly
    $  

In: Finance

A) You are expecting to receive $300 at the end of each year in years 3,...

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...

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...

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
  1. Compute the arithmetic mean annual rate of return for each stock. Round your answers to one decimal place.

    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 .

  2. Compute the standard deviation of the annual rate of return for each stock. (Use Chapter 1 Appendix if necessary.) Do not round intermediate calculations. Round your answers to three decimal places.

    Stock T:   %

    Stock B:   %

    By this measure, which is the preferable stock?

    -Select-Stock TStock BItem 7 is the preferable stock.

  3. Compute the coefficient of variation for each stock. (Use the Chapter 1 Appendix if necessary.) Do not round intermediate calculations. Round your answers to four decimal places.

    Stock T:

    Stock B:

    By this relative measure of risk, which stock is preferable?

    -Select-Stock TStock BItem 10 is the preferable stock.

  4. Compute the geometric mean rate of return for each stock. Round your answers to three decimal places.

    Stock T:   %

    Stock B:   %

In: Finance

Discuss the pros and cons of tax-backed and revenue municipal bonds and the advantages and disadvantages...

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...

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...

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....

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