Calculate the net profit margin and explain what it means


Part A-Budgeting & Financial Analysis

Assume the following data for Spring Break Corp:

Statement of Income:                                               Balance Sheet:

2017                                                                            2017                2016

 

Sales                           $750                                        Current Assets        $1,050                 $840   

Costs                             300                                        PP&E                            650                  400

Op Income                    450                                        Goodwill                       150                  100

Interest                            40                                        Total Assets                1,850               1,340

Pre-tax Income             410   

Taxes                            160                                        Current Liabilities          250                  200

Net income                 $250                                        Notes Payable                 150                  120

                                                                                    Revolving Credit Line   150                  110

                                                                                    Deferred taxes            20                    10

                                                                                    Total Liabilities              570                  440

                                                                                    Shareholders' Equity     1,280                   900

                                                                                                                     $1,850             $1,340

1. Calculate the net profit margin and explain what it means.

2. Calculate the ROE (return on equity) and explain what it means.

3. Calculate the current Debt/Total Capital ratio and explain what it means.

4. Calculate the asset turnover ratio and explain what it means.

5. Based on the following assumptions, what is the expected growth (bps) in operating margin in 2018.

a. Sales projected to grow 12.0% each year

b. Costs expected to leverage 50 bps (basis points) as a percentage of sales

c. Interest expense projected to stay fixed at $40

d. Taxes expected to be 20% as a result of the new tax plan in 2018

Part B - Financial Analysis Short Answer

You are required to show all your work to receive full credit.

If using a financial calculator, please list your inputs and the function used.

If using excel, please download "Midterm Backup" file under Assignments on Blackboard and submit exam through Blackboard.

If using paper, please detail all calculations.

 

Year 1

Year 2

Year 3

Project A

$400

$400

$400

Project B

$180

$420

$600

Project C

$600

$420

$180

1. At an interest rate of 12%, which of the following sequences of cash flows should you prefer and why?

2. Assume Go Fish, Inc. has about 6.0 million shares outstanding and the stock price is $24.50. Also, assume the P/E ratio is about16.4x. Calculate the approximate market capitalization for Go Fish, Inc.

3. A government bond has a face value of 100 euros, a coupon rate of 5.5 percent and matures in six years. The bond pays annual interest payments. Calculate the yield to maturity of the bond (in euros) if the price of the bond is 105 euros.

4. Tapped Out is a no-growth firm and has 1.3 million shares outstanding. It expects to earn a constant $11.5 million per year on its assets. If it has no debt, all earnings are paid out as dividends, and the cost of capital is 12.3%, calculate the current price per share of the stock.

5. ABC Co. has $7,500,000 of revenue today. It is estimated to grow 15% next year, 13% the following year and 11% in each of the next 2 years. What is the CAGR?

6. Joe Condo has taken a 30-year $425,000 mortgage, payable monthly, on his condo at an interest rate of 6.20% per year. What is the remaining balance (or value) of the mortgage after 6 years?

PART C - Short Answer

1. Please give one example of the following decisions a company may face:

- Investment decision

- Financing decision

2. What is the relationship between the yield to maturity and coupon rate on a premium bond?

3. During which stage of company's lifecycle would you expect it to have higher payout ratios and why?

4. Why did Prof. Kaplowitz highlight the Doritos/Mountain Dew Super Bowl commercial as a good use of marketing budget?

5. Rank these securities from most to least risky.

a. SeniorSecured Bond

b. Common Stock

c. Subordinateddebt

d. Preferred Stock

6. What is the NPV rule?

7. Does Harvard Athletic Department break even from a budget standpoint in 2018? Why or why not?

Solution Preview :

Prepared by a verified Expert
Financial Management: Calculate the net profit margin and explain what it means
Reference No:- TGS02943387

Now Priced at $30 (50% Discount)

Recommended (95%)

Rated (4.7/5)