KFA is considering investing in a new drone technology costing $12 million. It has a 5 year life (no salvage value) and will save KFA $3.5 million/year in pre-tax operating costs. It will need an up-front working capital investment of $300,000. KFA's cost of capital is 8.0% and its tax rate is 21.0%. Their current technology has a $5 million book value but a $1 million salvage value. What are the NPV and IRR of the decision to replace the old technology?
In: Finance
KFA expects to pay the following dividends over the next 4 years: $3.00, $4.00, $5.00, and $6.00. After that, it expects to pay dividends that grow at 4%/year. If the required equity return is 15%, what should be today's share price?
In: Finance
KFA has issued a 100-year coupon bond with par of $1,000, and a 6.50% annual coupon paid semi-annually. Calculate its price for each of the following three YTM scenarios: 4.0%, 6.0%, and 8.0%.
In: Finance
The following financials are presented for Apple, Inc. for the years 2017 and 2018. (All values in USD million)
|
2018 |
2017 |
|
|
Cash and cash equivalents |
25,913 |
20,289 |
|
Marketable securities |
40,388 |
53,892 |
|
Accounts receivable, net |
23,186 |
17,874 |
|
Inventories |
3,956 |
4,855 |
|
Other current assets |
37,896 |
31,735 |
|
Total current assets |
1,31,339 |
1,28,645 |
|
Total non-current assets |
2,34,386 |
2,46,674 |
|
Total Assets |
$3,65,725 |
$3,75,319 |
|
Current liabilities: |
||
|
Accounts payable |
$55,888 |
$44,242 |
|
Other current liabilities |
60,978 |
56,572 |
|
Total current liabilities |
$1,16,866 |
$1,00,814 |
|
Total non-current liabilities |
1,41,712 |
1,40,458 |
|
Total liabilities |
2,58,578 |
2,41,272 |
|
Common Stock |
40,201 |
35,867 |
|
Retained Earnings |
66,946 |
98,180 |
|
Total shareholders' equity |
1,07,147 |
1,34,047 |
|
Total liabilities and shareholders' equity |
3,65,725 |
3,75,319 |
|
Net Sales |
2,65,595 |
2,29,234 |
|
Cost of Sales |
1,63,766 |
1,41,048 |
Required:
In: Finance
James Horner is considering an investment scheme, to fund his house purchase after 6 years, with following cash deposits for a period of 6 years.
|
Year |
1 |
2 |
3 |
4 |
5 |
6 |
|
Cash deposit ($) |
10,000 |
12,000 |
14,000 |
16,000 |
18,000 |
20,000 |
In: Finance
Bonus Value. You have a bond that pays $ 100 of annual interest, with a value of $ 1,000 and matures in 15 years. Your required rate of return is 12%.
a. Calculate the value of the bonus
b. How does the value change if your required rate of return:
1. Increase to 15%
2. Decrease to 8%
In: Finance
A project requires an initial investment of $100,000 and is expected to produce a cash inflow before tax of $27,200 per year for five years. Company A has substantial accumulated tax losses and is unlikely to pay taxes in the foreseeable future. Company B pays corporate taxes at a rate of 21% and can claim 100% bonus depreciation on the investment. Suppose the opportunity cost of capital is 10%. Ignore inflation. a. Calculate project NPV for each company. b. What is the IRR of the after-tax cash flows for each company?
In: Finance
A restaurant prepares 200.00 pizza slices and sells them at a rate of $15.00/slice. Expenses for the restaurant include raw material for pizza at $6.00 per slice, $124.00 for monthly rental and monthly insurance of $20.00. Lost sale are taken as $5.00 per unhappy customer. Leftover pizza can be sold for $2.00. The restaurant is open only for 25 days in a month. Today there was a party at nearby office so the demand for pizza went up to 224.00 slices. How much profit could the restaurant earn today?
In: Finance
Case Study: Rent vs Own
You are considering an option to purchase or rent a single residential property. You can rent it for $4,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes.
Alternatively, you can purchase this property for $300,000 and finance it with an 80% mortgage at 7% interest, 25 year - fixed. The loan can be prepaid at any time with no penalty.
You have done research in the market and found that properties have historically appreciated at an annual rate of 4% per year. Rents on similar properties have also increased at the same rate. Maintenance and insurance are currently $2,500 each per year and they have been increasing at a rate of 4% per year. Property taxes have generally been about 3% of the property value each year.
If you purchase, the plan is to occupy the property for at least four years. Selling costs would be 7% in the year of sale.
Based on this information you must decide:
In: Finance
A Restaurant is open only for 25 days in a month.
Expenses for the restaurant include raw material for each
sandwich at $6.00 per slice, $1,004.00 as monthly rental and
$470.00 monthly as insurance. They consider the cost of lost sales
as $5.00 per item. They are able to sell any leftover sandwiches
for $3. They prepares 200.00 sandwiches and sells them at a rate of
$12.00/sandwich.
Today there was a party at nearby office so the demand for
sandwiches rose to 226.00. How much profit did the restaurant earn
today?
In: Finance
Using the Vehicle Ratings Excel file, create formulas using nested IF, AND, and OR functions to implement the three rating schemes described on the spreadsheet.
| Rating 1 | ||||||||||||||||
| If the vehicle has A/C and a sunroof or it is newer than 2013, then YES, otherwise NO. | ||||||||||||||||
| Rating 2 | ||||||||||||||||
| If the vehicle is Red and does not have high miles, then YES, otherwise if it is a Ford or Chevy, MAYBE, otherwise NO. | ||||||||||||||||
| Rating 3 | ||||||||||||||||
| If the vehicle is older than 2013 and is priced under $15,000 or it is a Honda with a sunroof, then YES, otherwise, if the vehicle is a black Accord or black Corolla, then MAYBE, otherwise NO. |
| Make | Model | Year | Color | A/C | Sunroof | Mileage | High Miles | Price | Rating 1 | Rating 2 | Rating 3 |
| Toyota | Corolla | 2009 | Silver | No | Yes | 73,497 | No | $10,497 | |||
| Chevrolet | Malibu | 2012 | Blue | No | Yes | 84,690 | No | $11,489 | |||
| Ford | Fusion | 2014 | Black | Yes | No | 109,308 | Yes | $11,815 | |||
| Honda | Accord | 2013 | Red | No | No | 85,353 | No | $12,493 | |||
| Ford | Focus | 2014 | Black | Yes | No | 103,742 | Yes | $12,507 | |||
| Toyota | Corolla | 2014 | Black | No | Yes | 109,295 | Yes | $12,593 | |||
| Honda | Civic | 2012 | White | Yes | Yes | 119,522 | Yes | $13,333 | |||
| Chevrolet | Impala | 2013 | Blue | Yes | No | 108,226 | Yes | $13,630 | |||
| Chevrolet | Impala | 2009 | Blue | Yes | Yes | 111,691 | Yes | $13,980 | |||
| Ford | Focus | 2012 | Black | No | Yes | 75,772 | No | $14,251 | |||
| Honda | Accord | 2012 | Silver | Yes | No | 75,220 | No | $14,258 | |||
| Chevrolet | Malibu | 2012 | Blue | No | No | 81,587 | No | $15,246 | |||
| Ford | Fusion | 2010 | Red | No | Yes | 79,049 | No | $15,790 | |||
| Honda | Civic | 2009 | Blue | Yes | No | 88,548 | No | $16,036 | |||
| Toyota | Camry | 2013 | Silver | Yes | Yes | 115,050 | Yes | $16,344 | |||
| Honda | Accord | 2013 | Silver | No | No | 77,072 | No | $16,355 | |||
| Chevrolet | Malibu | 2011 | Blue | No | Yes | 82,792 | No | $16,556 | |||
| Toyota | Camry | 2010 | Red | Yes | Yes | 88,163 | No | $17,248 | |||
| Chevrolet | Silverado | 2009 | White | No | No | 100,179 | Yes | $17,964 | |||
| Toyota | Corolla | 2013 | Blue | Yes | Yes | 117,039 | Yes | $17,965 | |||
| Honda | Civic | 2012 | Red | Yes | No | 73,533 | No | $19,722 | |||
| Honda | Civic | 2011 | White | Yes | No | 88,786 | No | $19,864 | |||
| Chevrolet | Impala | 2011 | Silver | Yes | Yes | 77,060 | No | $20,339 | |||
| Ford | F-150 | 2014 | Red | Yes | No | 105,489 | Yes | $20,380 | |||
| Ford | Fusion | 2013 | Silver | No | No | 109,223 | Yes | $20,532 | |||
| Ford | F-150 | 2012 | Red | No | No | 76,025 | No | $20,659 | |||
| Honda | Accord | 2010 | Blue | Yes | No | 76,701 | No | $21,138 | |||
| Chevrolet | Silverado | 2014 | Silver | Yes | No | 72,319 | No | $21,148 | |||
| Chevrolet | Malibu | 2013 | White | No | No | 117,518 | Yes | $21,183 | |||
| Chevrolet | Silverado | 2009 | Black | No | Yes | 101,839 | Yes | $21,226 | |||
| Chevrolet | Malibu | 2014 | Blue | Yes | No | 80,179 | No | $21,466 | |||
| Toyota | Camry | 2010 | Blue | No | Yes | 74,937 | No | $21,976 | |||
| Ford | F-150 | 2011 | Black | Yes | Yes | 117,249 | Yes | $22,883 | |||
| Ford | Focus | 2014 | Silver | Yes | No | 77,527 | No | $23,235 | |||
| Ford | Fusion | 2011 | White | Yes | Yes | 81,907 | No | $23,835 |
In: Finance
you have the choice of two investments of equal risk. The required return for both is 8%. The first pays 1500 per month for 30 years and starts in 2 years. The second pays 15000 per year in perpetuity, but starts in 3 years. If the cost of both the investments is the same, which one would you prefer and why?
In: Finance
Bond X is noncallable and has 20 years to maturity, a 7% annual coupon, and a $1,000 par value. Your required return on Bond X is 10%; and if you buy it, you plan to hold it for 5 years. You (and the market) have expectations that in 5, years the yield to maturity on a 15-year bond with similar risk will be 7%. How much should you be willing to pay for Bond X today? (Hint: You will need to know how much the bond will be worth at the end of 5 years.) Round your answer to the nearest cent.
In: Finance
Woodbridge Manufacturing is also considering developing a new assembly line on which to build another new product (not covered in the text). In what category should the costs listed below be placed:
Initial investment outlay (time0)
Supplemental annual cash flows (time1 through timeN)
Terminal value (timeN), or Disregarded?
Also state your reasoning for choosing that classification.
Consider each element individually.
This product has been developed over the past three years, at a
total cost of $125,000.
The building that Woodbridge is planning to be used is currently
rented out to another company for $10,000 per month, and they are
on a month-to-month lease so the lease can be terminated with 90
days' notice.
The new product will replace a current product, which is currently
generating $12,000 per month in free cash flow (cash earnings less
applicable costs).
The machines will cost $750,000.
Travel to see similar machines in operation at another company's
factory costed $3,500.
Freight and installation for the machines will cost $75,000.
It is projected that the additional inventories valued at $80,000
will be required to support sales of the product.
Woodbridge will offer 90 day credit terms to purchasers of the new
product which are expected to expand accounts receivable by an
average of $145,000.
The gross profit (or gross margin) on the sales of the product is
expected to be $360,000 per year for the five years of the
project.
Purchases of material for the project is expected to increase the
balance of the accounts payable by $32,000 during the project
life.
Interest on a loan taken out around the time of starting the
project will be $12,000 per year.
The salvage value of the machines is expected to be $236,000 at the
end of the project.
In: Finance
A project has an initial cost of $52,125, expected net cash inflows of $12,000 per year for 7 years, and a cost of capital of 12%. What is the project's discounted payback period? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places.
In: Finance