Questions
PLEASE ANSWER ALL THE QUESTIONS: It’s been 2 months since you took a position as an...

PLEASE ANSWER ALL THE QUESTIONS:

It’s been 2 months since you took a position as an assistant financial analyst at Caledonia Products. Although your boss has been pleased with your work, he is still a bit hesitant about unleashing you without supervision. Your next assignment involves both the calculation of the cash flows associated with a new investment under consideration and the evaluation of several mutually exclusive projects.

Given your lack of tenure at Caledonia, you have been asked not only to provide a recommendation but also to respond to a number of questions aimed at judging your understanding of the capital-budgeting process. The memorandum you received outlining your assignment follows:

We are considering the introduction of a new product. Currently we are in the 34 percent marginal tax bracket with a 15 percent required rate of return or cost of capital. This project is expected to last 5 years and then, because this is somewhat of a fad product, be terminated. The following information describes the new project:

Cost of new plant and equipment:                   $7,900,000

Shipping and installation costs:                                     $100,000

Sales price per unit:                                                      $300/unit in years 1 through 4, $260/unit in year 5

Variable cost per unit:                                                      $180/unit

Annual fixed costs:                                                      $200,000 per year in years 1–5

Working-capital requirements:

There will be an initial working-capital requirement of $100,000 just to get production started. For each year, the total investment in net working capital will be equal to 10 percent of the dollar value of sales for that year. Thus, the investment in working capital will increase during years 1 through 3, then decrease in year 4. Finally, all working capital is liquidated at the termination of the project at the end of year 5.

Use the simplified straight-line method over 5 years. Assume that the plant and equipment will have no salvage value after 5 years.

Year                                    Units Sold

1                                    70,000

2                                    120,000

3                                    140,000

4                                    80,000

5                                     60,000

The purpose/risk classes and preassigned required rates of return are as follows:

  • Replacement decision 12%
  • Modification or expansion of existing product line 15%
  • Project unrelated to current operations 18%
  • Research and development operations 20%

a. Should Caledonia focus on cash flows or accounting profits in making its capital-budgeting decisions? Should the company be interested in incremental cash flows, incremental profits, total free cash flows, or total profits?

b. How does depreciation affect free cash flows?

c. How do sunk costs affect the determination of cash flows?

d. What is the project’s initial outlay?

e. What are the differential cash flows over the project’s life?

f. What is the terminal cash flow?

g. Draw a cash-flow diagram for this project.

h. What is its net present value?

i. What is its internal rate of return?

j. What is its modified internal rate of return?

k. Should the project be accepted? Why or why not?

l. In capital budgeting, risk can be measured from three perspectives. What are those three measures of a project’s risk?

m. Explain how simulation works. What is the value in using a simulation approach?

n. What is sensitivity analysis and what is its purpose?

In: Finance

We are evaluating a project that costs $756,000, has a life of 6 years, and has...

We are evaluating a project that costs $756,000, has a life of 6 years, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 32,000 units per year. Price per unit is $60, variable cost per unit is $25, and fixed costs are $665,000 per year. The tax rate is 24 percent and we require a return of 12 percent on this project.

a.

Calculate the accounting break-even point. (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

b-1. Calculate the base-case cash flow and NPV. (Do not round intermediate calculations and round your NPV answer to 2 decimal places, e.g., 32.16.)
b-2. What is the sensitivity of NPV to changes in the sales figure? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)
c. What is the sensitivity of OCF to changes in the variable cost figure? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

a.

Break – even point

units

b-1.

Cash Flow

NPV

b-2.

ΔNPV/ΔQ

c.

ΔOCF/ΔVC

In: Finance

Identify the tools and techniques available to managers in the area of forecasting and planning. Discuss...

Identify the tools and techniques available to managers in the area of forecasting and planning. Discuss how you will use these tools to forecast sales and prepare a financial plan for your company?

In: Finance

You have been asked by the president of your company to evaluate the proposed acquisition of...

You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck. The truck's basic price is $275,000, and it will cost another $25,000 to modify it for special use by your firm. The truck falls into the MACRS three-year class, and it will be sold after three years for

$50,000. Use of the truck will require an increase in net operating working capital

(spare parts inventory) of $25,000. The truck will have no effect on revenues, but it is expected to save the firm $125,000 per year in before-tax operating costs, mainly labor. The firm's cost of capital is 10% and the marginal tax rate is 35 percent. Should the company accept/reject the project?

NPV?

IRR?

MIRR?

Payback?

Decision?

In: Finance

Discuss the traditional argument that the firm can lower its cost of capital and increase market...

Discuss the traditional argument that the firm can lower its cost of capital and increase market value of the firm using leverage and the non-traditional argument that leverage is irrelevant. Based on the understanding of the two sides, which approach will you use if you have to make a decision on capital structure in your firm.

In: Finance

is my answer correct ? Problem 2-13 Repeat Problem 6 assuming the corporation is an S...

is my answer correct ?

Problem 2-13
Repeat Problem 6 assuming the corporation is an S corporation.
Corporate Tax Rate 40%
Personal Tax Rate 30%
Earnings per share $2.00
Remaining after all taxes $0.60

In: Finance

Distinguish between operating leases and financial leases. Would you be more likely to find an operating...

Distinguish between operating leases and financial leases. Would you be more likely to find an operating lease employed for a fleet of aircrafts or a manufacturing plant? Explain.

In: Finance

Financing Deficit Stevens Textile Corporation's 2018 financial statements are shown below: Balance Sheet as of December...

Financing Deficit

Stevens Textile Corporation's 2018 financial statements are shown below:

Balance Sheet as of December 31, 2018 (Thousands of Dollars)

Cash $ 1,080 Accounts payable $ 4,320
Receivables 6,480 Accruals 2,880
Inventories 9,000 Line of credit 0
   Total current assets $16,560 Notes payable 2,100
Net fixed assets 12,600    Total current liabilities $ 9,300
Mortgage bonds 3,500
Common stock 3,500
Retained earnings 12,860
   Total assets $29,160    Total liabilities and equity $29,160

Income Statement for January 1 - December 31, 2018 (Thousands of Dollars)

Sales $36,000
Operating costs 32,440
   Earnings before interest and taxes $ 3,560
Interest 460
   Pre-tax earnings $ 3,100
Taxes (40%) 1,240
Net income $ 1,860
Dividends (45%) $    837
Addition to retained earnings $ 1,023
  1. Suppose 2019 sales are projected to increase by 20% over 2018 sales. Use the forecasted financial statement method to forecast a balance sheet and income statement for December 31, 2019. The interest rate on all debt is 8%, and cash earns no interest income. Assume that all additional debt in the form of a line of credit is added at the end of the year, which means that you should base the forecasted interest expense on the balance of debt at the beginning of the year. Use the forecasted income statement to determine the addition to retained earnings. Assume that the company was operating at full capacity in 2018, that it cannot sell off any of its fixed assets, and that any required financing will be borrowed as notes payable. Also, assume that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Determine the additional funds needed. Do not round intermediate calculations. Round your answers to the nearest dollar.
    Total assets: $ ?????
    AFN: $ ?????
  2. What is the resulting total forecasted amount of the line of credit? Do not round intermediate calculations. Round your answer to the nearest dollar.
    $ ?????
  3. In your answers to Parts a and b, you should not have charged any interest on the additional debt added during 2019 because it was assumed that the new debt was added at the end of the year. But now suppose that the new debt is added throughout the year. Don't do any calculations, but how would this change the answers to parts a and b?
    If debt is added throughout the year rather than only at the end of the year, interest expense will be (SELECT ANSWER: higher, lower) than in the projections of part a. This would cause net income to be (SELECT ANSWER: higher, lower), the addition to retained earnings to be (SELECT ANSWER: higher, lower), and the AFN to be (SELECT ANSWER: higher, lower). Thus, you would have to (SELECT ANSWER: Add in, Subtract from) new debt.

In: Finance

Brian runs a small corner store. Last year he had sales of $260,000. The cost of...

Brian runs a small corner store. Last year he had sales of $260,000. The cost of goods sold was $130,000 and depreciation was $40,000. He did not pay any interest. His taxation rate was 32.5%. His fixed (non-current) assets were valued at $250,000 at the beginning of the year. During the year he invested in some refrigeration equipment and now his fixed assets are valued at $270,000. His net working capital fell by $30,000 because Brian adopted a stricter inventory management process. How much free cash flow (FCF) has Brian's corner store generated for him this year?

Select one: a. $40,750 b. $100,500 c. $70,750 d. $32,077 e. $90,800

In: Finance

Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December...

Financing Deficit

Garlington Technologies Inc.'s 2018 financial statements are shown below:

Balance Sheet as of December 31, 2018

Cash $   180,000 Accounts payable $   360,000
Receivables 360,000 Notes payable 156,000
Inventories 720,000 Line of credit 0
Total current assets $1,260,000 Accruals 180,000
Fixed assets 1,440,000 Total current liabilities $   696,000
Common stock 1,800,000
Retained earnings 204,000
Total assets $2,700,000 Total liabilities and equity $2,700,000

Income Statement for December 31, 2018

Sales $3,600,000
Operating costs 3,279,720
EBIT $  320,280
Interest 18,280
Pre-tax earnings $  302,000
Taxes (40%) 120,800
Net income 181,200
Dividends $  108,000

Suppose that in 2019 sales increase by 5% over 2018 sales and that 2019 dividends will increase to $128,000. Forecast the financial statements using the forecasted financial statement method. Assume the firm operated at full capacity in 2018. Use an interest rate of 10%, and assume that any new debt will be added at the end of the year (so forecast the interest expense based on the debt balance at the beginning of the year). Cash does not earn any interest income. Assume that the all new-debt will be in the form of a line of credit. Enter your answers as positive values. Do not round intermediate calculations. Round your answers to the nearest dollar.

Garlington Technologies Inc.
Pro Forma Income Statement
December 31, 2019
Sales $ ?
Operating costs $ ?
EBIT $ ?
Interest $ ?
Pre-tax earnings $ ?
Taxes (40%) $ ?
Net income $ ?
Dividends: $ ?
Addition to RE: $ ?


Garlington Technologies Inc.
Pro Forma Balance Statement
December 31, 2019
Cash $ ?
Receivables $ ?
Inventories $ ?
Total current assets $ ?
Fixed assets $ ?
Total assets $ ?
Accounts payable $ ?
Notes payable $ ?
Accruals $ ?
Total current liabilities $ ?
Common stock $ ?
Retained earnings $ ?
Total liabilities and equity $ ?

Please Answer the boxes with the Question Mark in them. Thank you!

In: Finance

"Freakonomics" is a best selling book on unexpected applications of economics. The authors have a website...

"Freakonomics" is a best selling book on unexpected applications of economics. The authors have a website to accompany the book. On the "Freakonomics" blog, a topic of discussion was "What if We Paid Bank Regulators for Performance?" If banks fail (that is, go out of business) as many did in 2008 - 2009, the regulators would not earn much money. If the banking system is healthy, the regulators would receive a bonus.

Do you think this is a good idea or a bad idea? Why? Keep in mind that the bonuses would be for regulators, such as officials at the Federal Reserve, and not for the bank executives. Be sure to include in your discussion what the goals of financial regulation are, and how this plan would affect those goals.

In: Finance

AFN EQUATION Broussard Skateboard's sales are expected to increase by 20% from $7.4 million in 2018...

AFN EQUATION

Broussard Skateboard's sales are expected to increase by 20% from $7.4 million in 2018 to $8.88 million in 2019. Its assets totaled $5 million at the end of 2018.
Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 3%, and the forecasted payout ratio is 50%. What would be the additional funds needed? Do not round intermediate calculations. Round your answer to the nearest dollar.
$ ????

Assume that the company's year-end 2018 assets had been $6 million. Is the company's "capital intensity" ratio the same or different?

The capital intensity ratio is measured as A0*/S0. Broussard's current capital intensity ratio is (SELECT ANSWER: Higher than, Lower than, equal to) that of the firm with $6 million year-end 2018 assets; therefore, Broussard is (SELECT ANSWER: Less, More, Same) capital intensive - it would require (SELECT ANSWER: A Smaller, A larger, The same) increase in total assets to support the increase in sales.

In: Finance

Amelia currently has $1,000 in an account with an annual rate of return of 4.3%. She...

Amelia currently has $1,000 in an account with an annual rate of return of 4.3%. She wants to have $3000 for a trip to Canada when she graduates in 4 years. How much will she have to save each month to afford her trip?

In: Finance

AFN equation Broussard Skateboard's sales are expected to increase by 20% from $9.0 million in 2018...

AFN equation

Broussard Skateboard's sales are expected to increase by 20% from $9.0 million in 2018 to $10.80 million in 2019. Its assets totaled $2 million at the end of 2018.
Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 5%, and the forecasted payout ratio is 65%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar.

In: Finance

Below is a spreadsheet that has the annual return measured for 12 different stock investments. The...

Below is a spreadsheet that has the annual return measured for 12 different stock investments. The spreadsheet shows the average return and standard deviation of the return for the past 15 years. Use this spreadsheet and spreadsheet commands to do the following:

Compute the return for each year on a portfolio that contains an equal investment in all 12 securities.

Compute the 15-year average return and standard deviation of return for the portfolio that consists of all 12 securities with equally weighted investment.

Compute the correlation and covariance between the return on company #12 and the return on the equally-weighted portfolio. Hint: There is a spreadsheet command that does this calculation.

Compute the beta of Company #12 using the information you have collected.

Now using the beta you created for Company #12, compute the required rate of return using the Capital Asset Pricing Model (CAPM), assuming that the average market return is the return of your equally-weighted portfolio and the risk-free rate of return is 2.5%.

If you were told analysts estimate that Company #12 will have a 5% rate of return next year, would you buy the stock? Why or why not?

COMPUTE ALL CALCULATIONS IN AN EXCEL SPREADSHEET AND POST IT HERE, THANK YOU

Comp. #1 Comp. #2 Comp. #3 Comp. #4 Comp. #5 Comp. #6 Comp. #7 Comp. #8 Comp. #9 Comp. #10 Comp. #11 Comp. #12
Return Return Return Return Return Return Return Return Return Return Return Return
2012 3.60% -10.04% -1.38% 5.25% -3.50% 0.14% 5.33% -2.55% 14.18% 14.76% -3.35% 0.10%
2011 54.44% 23.22% 0.55% 15.35% 0.22% 22.32% 23.55% 23.00% 36.36% 42.15% 9.90% -0.10%
2010 -29.30% -18.92% -44.54% -22.24% -17.66% 11.87% -1.93% -5.68% -39.86% 6.04% 5.36% -9.57%
2009 -37.57% -11.88% -6.00% -13.93% -16.09% 6.23% -15.42% -55.35% -5.78% 9.63% 13.75% 33.93%
2008 -11.00% -11.64% -9.39% -4.00% -2.80% 12.18% 3.33% -3.33% 4.18% -4.76% -7.85% -5.33%
2007 7.11% 13.59% 0.52% 26.35% -6.06% 23.92% 22.90% 4.23% -46.36% 59.17% 6.02% -37.79%
2006 20.91% 18.92% -44.54% 2.24% -17.66% 11.87% 1.93% -5.68% 39.86% 6.04% 5.36% 9.57%
2005 16.02% 11.88% -6.00% -13.93% 16.09% 6.23% 15.42% 55.35% -5.78% -9.63% 13.75% 33.93%
2004 55.35% 23.14% 43.33% 23.33% 0.33% -1.08% -1.44% 38.53% 35.44% 9.40% -15.05% 49.56%
2003 -11.56% 23.00% -38.30% -3.53% 5.07% -6.58% -5.12% -13.43% -12.18% -24.68% -7.69% -37.39%
2002 11.52% 39.67% -28.46% -20.72% -6.22% -8.25% 22.70% -2.60% -32.87% -13.16% -34.55% -20.56%
2001 -0.23% -1.48% -51.99% 7.35% 16.54% 1.83% 32.25% 47.38% 11.10% 2.96% -51.00% -14.48%
2000 3.10% 13.56% -7.33% -11.03% 17.69% 44.92% 0.93% -3.72% -9.20% -4.87% 298.67% 6.04%
1999 -3.43% -7.16% 47.74% 2.39% 4.27% 31.57% 19.44% -3.90% 12.12% 53.37% -19.46% 62.66%
1998 31.48% 45.52% 53.49% 29.15% 58.33% 67.99% 25.12% 0.44% 26.83% 50.67% 40.62% 6.72%

In: Finance