In: Finance
You are a manager at Percolated Fiber, which is considering expanding its operations in synthetic fiber manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $1.6 million for this report, and I am not sure their analysis makes sense. Before we spend the $23 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars):
|
Project Year |
||||||
|
Earnings Forecast ($ million) |
1 |
2 |
. . . |
9 |
10 |
|
|
Sales revenue |
30.00030.000 |
30.00030.000 |
30.00030.000 |
30.00030.000 |
||
|
minus−Cost of goods sold |
18.00018.000 |
18.00018.000 |
18.00018.000 |
18.00018.000 |
||
|
equals=Gross profit |
12.00012.000 |
12.00012.000 |
12.00012.000 |
12.00012.000 |
||
|
minus−Selling, general, and administrative expenses |
1.8401.840 |
1.8401.840 |
1.8401.840 |
1.8401.840 |
||
|
minus−Depreciation |
2.3002.300 |
2.3002.300 |
2.3002.300 |
2.3002.300 |
||
|
equals=Net operating income |
7.8607.860 |
7.8607.860 |
7.8607.860 |
7.8607.860 |
||
|
minus−Income tax |
2.7512.751 |
2.7512.751 |
2.7512.751 |
2.7512.751 |
||
|
equals=Net unlevered income |
5.1095.109 |
5.1095.109 |
5.1095.109 |
5.1095.109 |
||
All of the estimates in the report seem correct. You note that the consultants used straight-line depreciation for the new equipment that will be purchased today (year 0), which is what the accounting department recommended. The report concludes that because the project will increase earnings by $5.109 million per year for ten years, the project is worth $51.09 million. You think back to your halcyon days in finance class and realize there is more work to be done!
First, you note that the consultants have not factored in the fact that the project will require $14 million in working capital upfront (year 0), which will be fully recovered in year 10. Next, you see they have attributed $1.84 million of selling, general and administrative expenses to the project, but you know that $0.92 million of this amount is overhead that will be incurred even if the project is not accepted. Finally, you know that accounting earnings are not the right thing to focus on!
a. Given the available information, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposed project?
b. If the cost of capital for this project is 16%,
what is your estimate of the value of the new project?
Given the available information, what are the free cash flows in years 0 through 10 that should be used to evaluate the proposed project?
The free cash flow for year 0 is $____million. (Round to three decimal places and enter a decrease as a negative number.)
The free cash flow for years 1 to 9 is $_____million. (Round to three decimal places and enter a decrease as a negative number.)
The free cash flow for year 10 is $____million. (Round to three decimal places and enter a decrease as a negative number.)
b. If the cost of capital for this project is 16 %
what is your estimate of the value of the new project?
The value of the project is $____million. (Round to three decimal places.)
In: Finance
Arnold Inc. is considering a proposal to manufacture high-end
protein bars used as food supplements by body builders. The project
requires use of an existing warehouse, which the firm acquired
three years ago for $ 3million and which it currently rents out for
$108,000. Rental rates are not expected to change going forward. In
addition to using the warehouse, the project requires an upfront
investment into machines and other equipment of $1.4million. This
investment can be fully depreciated straight-line over the next 10
years for tax purposes. However, Arnold Inc. expects to terminate
the project at the end of eight years and to sell the machines and
equipment for $472,000. Finally, the project requires an initial
investment into net working capital equal to 10 percent of
predicted first-year sales. Subsequently, net working capital is
10 percent of the predicted sales over the following year. Sales of
protein bars are expected to be $ 4.9million in the first year and
to stay constant for eight years. Total manufacturing costs and
operating expenses (excluding depreciation) are 80 percent
ofsales, and profits are taxed at 30 percent.
a. What are the free cash flows of the project?
b. If the cost of capital is 15 % what is the NPV of the
project?
a. What are the free cash flows of the project?
The FCF for year 0 is $ ____million. (Round to three decimal
places.)
The FCF for years 1-7 is $____million. (Round to three decimal
places.)
The FCF for year 8 is $_____ million. (Round to three decimal
places.)
b. If the cost of capital is 15 % what is the NPV of the
project?
The NPV of the project is $_____million. (Round to three
decimal places.)
In: Finance
9. Compute the average annual return and standard deviation of an evenly weighted portfolio of stocks and 10-year government bonds over the past five years ended December 31, 2018?
In: Finance
Suppose that you wish to save enough to fund $4,500 per month (in today's purchasing power) for 30 years of retirement. The fund you invest in during your working (or saving) years is expected to earn interest at 6% AR. At retirement, you will move your retirement funds into a less risky investment earning 4% AR. If you are 35 years from retirement, find the level of monthly savings (in current dollars) that will be required.
Please show work :)
In: Finance
You wish to purchase a new pickup truck. The dealership offers to finance $40,000 at a 2% annual rate (AR) with 36 monthly payments. The first payment starts 6 months from now. Market interest rates are 4% AR. Determine your true cost of purchasing the pickup (i.e., the present value of your payments).
Please show work. Thank you :)
In: Finance
A Chinese steelmaker is considering its strategy to expand globally. It is considering two possible choices. Choice A involves acquiring mining assets in Canada. Choice B involves acquiring a mining company in Australia. Forecasts indicate that the Canadian dollar is expected to appreciate while Australian dollar is expected to depreciate substantially over the next 3 years. Should the Chinese company expand into Australia or Canada? What factors may affect its decision?
In: Finance
1) A bank with a leverage ratio of 15 has a cost of debt of 2%pa
and a portfolio of assets with an expected yield of 4%pa. What are
the expected ROA net of debt funding costs and the expected ROE of
the bank, using the approach to defining leverage taken in the
lecture slides? Show your workings.
2) What will the ROA and ROE actually be if the yield on assets
turns out to be 3%? Show your workings. (1 mark)
3) What will the ROA and ROE actually be if the yield on assets
turns out to be 1%? Show your workings.
4) What is the unweighted bank’s capital (or E/A) ratio (i) for a
leverage ratio of 20 and (ii) for a leverage ratio of 30? Show your
workings. (1 mark)
5) Redo the above calculations in parts 1) and 3) for a leverage
ratio of 25. What affect does the higher leverage ratio have on
your answers? Show your workings.
6) What is the relationship between a bank’s capital ratio and the
risks and returns faced by (i) its shareholders and (ii) its
creditors? Explain your answers.
just need to answer question 5 and 6
In: Finance
| Purchase Price | $33,500.00 | Finance Rate Table | ||||
| less | Term | No Rebate | Rebate | |||
| Down Payment | $3,500.00 | 1 | 12.50% | 19.70% | ||
| Trade-in Value | $4,500.00 | 2 | 14.90% | 20.90% | ||
| Rebate | $1,000.00 | 3 | 17.30% | 22.10% | ||
| 4 | 18.50% | 23.30% | ||||
| Loan Amount | $24,500.00 | 5 | 19.70% | 24.50% | ||
| --------------------Term of Loan----------------------- | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| Finance Rate | 19.70% | 20.90% | 22.10% | 23.30% | 24.50% | |
| Monthly Payment | $2,266.03 | $1,257.75 | $936.93 | $789.29 | $711.94 | |
| Total Payment | $27,192.35 | $30,185.89 | $33,729.63 | $37,886.09 | $42,716.61 | |
| Finance Charge | $2,692.35 | $5,685.89 | $9,229.63 | $13,386.09 | $18,216.61 | |
Please answer the following below using your Automobile Loan Calculator workbook along with the following information:
| Term | No Rebate | Rebate |
| 1 | 12.5% | 19.7% |
| 2 | 14.9% | 20.9% |
| 3 | 17.3% | 22.1% |
| 4 | 18.5% | 23.3% |
| 5 | 19.7% |
24.5% |
A) If a customer elects to take the Rebate, what is the Loan Amount?
B) If a customer does not elect to take the rebate, what would the monthly payment be for a 3-year loan?
C) If a customer elects to take the $1,000 Rebate, what would be the Total Payments for a 5-year loan?
D) What is the difference in Monthly Payment amounts for customers who do and do not elect to take the Rebate for a 1-year loan?
E) What is the difference in Finance Charges for customers who do and do not elect to take the Rebate for a 1-year loan?
In: Finance
Please explain the below answer in simple terms:
Q: Explain how are nominal and real returns of equity investment
related with inflation
A: Nominal returns of equities are positively
related to inflation (0.31) where entirely all of the correlation
is between capital gains and inflation, while dividends and
inflation are uncorrelated. The real returns of equities are
uncorrelated with inflation. This implies that equities are a hedge
to inflation that is they are unaffected by inflation.
In: Finance
Company Y wants to deposit money in a bank account in order to be able to withdraw €50,000 after the first three years, and €60,000 after additional two years. The bank offers 6% annual interest rate for the first three years and 8% interest for the following years. What amount should Y deposit now?
In: Finance
| Purchase Price | $33,500.00 | Finance Rate Table | ||||
| less | Term | No Rebate | Rebate | |||
| Down Payment | $3,500.00 | 1 | 12.50% | 19.70% | ||
| Trade-in Value | $4,500.00 | 2 | 14.90% | 20.90% | ||
| Rebate | $1,000.00 | 3 | 17.30% | 22.10% | ||
| 4 | 18.50% | 23.30% | ||||
| Loan Amount | $24,500.00 | 5 | 19.70% | 24.50% | ||
| --------------------Term of Loan----------------------- | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| Finance Rate | 19.70% | 20.90% | 22.10% | 23.30% | 24.50% | |
| Monthly Payment | $2,266.03 | $1,257.75 | $936.93 | $789.29 | $711.94 | |
| Total Payment | $27,192.35 | $30,185.89 | $33,729.63 | $37,886.09 | $42,716.61 | |
| Finance Charge | $2,692.35 | $5,685.89 | $9,229.63 | $13,386.09 | $18,216.61 | |
Please answer the following below using your Automobile Loan Calculator workbook along with the following information:
| Term | No Rebate | Rebate |
| 1 | 12.5% | 19.7% |
| 2 | 14.9% | 20.9% |
| 3 | 17.3% | 22.1% |
| 4 | 18.5% | 23.3% |
| 5 | 19.7% |
24.5% |
A) If a customer elects to take the Rebate, what is the Loan Amount?
B) If a customer does not elect to take the rebate, what would the monthly payment be for a 3-year loan?
C) If a customer elects to take the $1,000 Rebate, what would be the Total Payments for a 5-year loan?
D) What is the difference in Monthly Payment amounts for customers who do and do not elect to take the Rebate for a 1-year loan?
E) What is the difference in Finance Charges for customers who do and do not elect to take the Rebate for a 1-year loan?
In: Finance
9. Profitability index Estimating the cash flow generated by $1 invested in a project The profitability index (PI) is a capital budgeting tool that is defined as the present value of a project’s cash inflows divided by the absolute value of its initial cash outflow. Consider this case: Happy Dog Soap Company is considering investing $2,750,000 in a project that is expected to generate the following net cash flows: Year Cash Flow Year 1 $275,000 Year 2 $500,000 Year 3 $475,000 Year 4 $475,000 Happy Dog Soap Company uses a WACC of 8% when evaluating proposed capital budgeting projects. Based on these cash flows, determine this project’s PI (rounded to four decimal places): 0.4869 0.5125 0.5638 0.4613 Happy Dog Soap Company’s decision to accept or reject this project is independent of its decisions on other projects. Based on the project’s PI, the firm should (ACCEPT or REJECT) the project? By comparison, the NPV of this project is (-$1,340,491, -$1,608,589, or -$1,072,343)?. On the basis of this evaluation criterion, Happy Dog Soap Company should INVEST or NOT INVEST in the project because the project WILL or WILL NOT increase the firm’s value.
In: Finance
Can someone please give details on how you solved them please!
Your firm just received an order from a customer for $50,000 of widgets. You have been tasked with evaluating the effect of time value of money on your firm’s cash flows (on a transaction-by-transaction basis). To fulfill this order your firm will need to produce and transport the widgets. This will take 50 days. Assume that the widgets will cost $30,000 in COGS; your firm is given 20 days to pay for the raw materials. Once the widgets are delivered to your customer, 40 days of trade credit will be provided to the customer. Assume a discount rate of 7%.
a. With the aforementioned assumptions, what is the NPV of this transaction?
b. Recalculate the NPV, assuming that your firm reduced the time needed to produce and transport the widgets to 35 days.
c. Next, treat the difference in NPV (NPV from part b minus NPV from part a) as a daily perpetuity and determine the total increase in firm value attributable to the improvement in inventory management.
In: Finance
In: Finance