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:
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 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 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 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 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 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 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 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 |
In: Finance
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 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 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 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 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 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 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