Evaluate a project that has a startup cost of $10,000, a projected cash flow of $3,000 at the end of the first year, $4,200 the second year, and $6,800 in the third and final year. Use 10% as the required rate/cost of capital |
1. Use the XNPV function to calculate the Net Present Value for the project in. Use today's date as the start date T0, and the same date a year later for T1 and so on. |
2. Use the IRR function to calculate the Internal Rate of Return for the project. |
3. Use the XIRR function to calculate the Internal Rate of Return for the project. Use today's date as the start date T0, and the same date a year later for T1 and so on. |
4: Use the MIRR function to calculate the Internal Rate of Return for the project, where the finance rate is 12% and the reinvestment rate is 10%. Then describe an advantage and a disadvantage of using MIRR vs XIRR. And what is the Discounted Payback Period for this project? |
In: Finance
Name |
Callable |
Sub-Product Type |
Coupon |
Maturity |
Ratings |
Last Sale |
|||
Moody's® |
S&P |
Price |
Yield |
||||||
V |
Yes |
Corporate Bond |
3.150 |
12/14/2025 |
Aa3 |
AA- |
106.061 |
2.040 |
|
V |
Yes |
Corporate Bond |
4.150 |
12/14/2035 |
Aa3 |
AA- |
119.011 |
2.652 |
In: Finance
The following spot and forward rates for the euro ($/euro) were reported:
Spot | 1.6360 | |
30-day forward | 1.6359 | |
90-day forward | 1.6359 | |
180-day forward | 1.6366 | |
a-1. Was the euro selling at a discount or premium in the forward market at 30 days.
Premium
Discount
a-2. Was the euro selling at a discount or premium in the forward market at 90 days.
Discount
Premium
a-3. Was the euro selling at a discount or premium in the forward market at 180 days.
Discount
Premium
b. What was the 30-day forward premium (or discount)? (Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answer to 2 decimal places.)
30-day forward premium/discount %
c. What was the 180-day forward premium (or discount)? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Negative answer should be indicated by a minus sign.)
180-day forward premium/discount %
d. Suppose you executed a 90-day forward contract
to exchange 210,000 euros into Canadian dollars. How many dollars
would you get 90 days hence?
Dollars for euros francs $
e. Assume a French bank entered into a 180-day forward contract with TD Bank to buy $210,000. How many euros will the French bank deliver in six months to get the Canadian dollars? (Do not round intermediate calculations. Round the final answer to the nearest whole dollar.)
Euros francs for dollars €
In: Finance
Even if project X has a higher IRR than project Y, project Y may have a higher net present value than project X. True or False?
In: Finance
Parramore Corp has $19 million of sales, $2 million of inventories, $4 million of receivables, and $3 million of payables. Its cost of goods sold is 70% of sales, and it finances working capital with bank loans at an 8% rate. Assume 365 days in year for your calculations. Do not round intermediate steps.
In: Finance
CURRENT ASSETS INVESTMENT POLICY
Rentz Corporation is investigating the optimal level of current assets for the coming year. Management expects sales to increase to approximately $3 million as a result of an asset expansion presently being undertaken. Fixed assets total $2 million, and the firm plans to maintain a 55% debt-to-assets ratio. Rentz's interest rate is currently 10% on both short-term and long-term debt (which the firm uses in its permanent structure). Three alternatives regarding the projected current assets level are under consideration: (1) a restricted policy where current assets would be only 45% of projected sales, (2) a moderate policy where current assets would be 50% of sales, and (3) a relaxed policy where current assets would be 60% of sales. Earnings before interest and taxes should be 12% of total sales, and the federal-plus-state tax rate is 40%.
Restricted policy | % | |
Moderate policy | % | |
Relaxed policy | % |
In: Finance
Refi Corporation is planning to repurchase part of its common stock by issuing corporate debt. As a result, the firm’s debt-equity ratio is expected to rise from 30 percent to 50 percent. The firm currently has $3 million worth of debt outstanding. The cost of this debt is 8 percent per year. The firm expects to have an EBIT of $1.29 million per year in perpetuity and pays no taxes. |
a. |
What is the market value of the firm before and after the repurchase announcement? (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to the nearest whole number, e.g., 1,234,567.) |
b. | What is the expected return on the firm’s equity before the announcement of the stock repurchase plan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
c. | What is the expected return on the equity of an otherwise identical all-equity firm? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
d. |
What is the expected return on the firm’s equity after the announcement of the stock repurchase plan? ( |
In: Finance
AFN EQUATION
Carlsbad Corporation's sales are expected to increase from $5 million in 2016 to $6 million in 2017, or by 20%. Its assets totaled $3 million at the end of 2016. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2016, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%.
|
In: Finance
1.Duration and Convexity
Your research department reports continuously compounded interest rates as
Maturity (Years) 0.5, 1.0, 1.5, 2.0
Interest Rate (%) 1.00, 1.50, 2.00, 2.00
(a) Use these rates to compute the prices Pz(0,1) and Pz(0,2) of one- and two-year zero coupon bonds, and the price Pc(0,2) of a two-year, 3% coupon bond. Coupons are paid semi-annually, and the face value of all bonds is 100.
(b) Obtain the coupon bond's duration and convexity.
(c) Suppose that the monthly changes in the interest rates have a mean of zero and a standard deviation of 0.5%. Obtain the monthly 95% Value at Risk and Expected Shortfall on the coupon bond.
(d) Construct a hedge portfolio of 1 coupon bond and k one-year zero coupon bonds that has zero duration. What is the value of k? What is the convexity of the hedge portfolio?
(e) Construct a hedge portfolio of 1 coupon bond, and k1 one-year zero coupon bonds and k2 two-year zero coupon bonds, that has zero duration and convexity. What are the values of k1 and k2?
(f) Suppose that the yield curve shifts upward with dr = 1%. Recalculate Pc(0,2), Pz(0,1) and Pz(0,2) and use this to calculate the change in the values of the hedge portfolios constructed in (d) and (e). Comment on the result.
In: Finance
GM is considering two mutually exclusive projects, A and B. Project A costs $150,000 and is expected to generate $50,000 in year one, $85,000 in year two, and $35,000 per year in years 3 and 4. Project B costs $120,000 and is expected to generate $64,000 in year one, $45,000 in year two, $25,000 in year three, and $55,000 in year four. GM's required rate of return for these projects is 10%. GM decides to use NPV to evaluate these projects. Which project or projects will they choose?
Project A
Project B
Projects A&B
GM would reject both projects
In: Finance
You would like to have $650,000 when you retire in 40 years. How
much should you invest each quarter if you can earn a rate of 2.7%
compounded quarterly?
a) How much should you deposit each quarter?
b) How much total money will you put into the account?
c) How much total interest will you earn?
In: Finance
1). Suppose everything else equal; a) the Central Bank raises the reserve requirement to 20 percent, b) the currency deposit ratio rises to 60 percent. Which development, a) or b) will affect the money multiplier more? Why?
2). Suppose the Central Bank of Turkey starts to pay interest on reserves. Under what circumstances this would affect the short term policy interest rate?
In: Finance
Treats | Food | Toys | ||
Cash Flows | ||||
Initial Investment | $ 4,000,000 | $ 3,800,000 | $ 4,400,000 | |
1 | $ 1,200,000 | $ 800,000 | $ 2,300,000 | |
2 | $ 1,400,000 | $ 1,000,000 | $ 1,900,000 | |
3 | $ 1,500,000 | $ 1,700,000 | $ 1,000,000 | |
4 | $ 1,800,000 | $ 2,200,000 | $ 800,000 | |
Std. Deviation of IRR | 10% | 8% | 12% | |
1. Calculate Payback Period, NPV, IRR, and MIRR for all projects. | ||||
Which project(s) should the firm accept? Explain in detail the reasons for your recomendation. | ||||
In: Finance
If it were unlevered, the overall firm beta for Wild Widgets Inc. (WWI) would be 0.7. WWI has a target debt/equity ratio of 1. The expected return on the market is 0.1, and Treasury bills are currently selling to yield 0.04. WWI one-year bonds (with a face value of $1,000) carry an annual coupon of 3% and are selling for $983.52. The corporate tax rate is 37%.(Round your answers to 2 decimal places before the percentage sign. (e.g., 10.23%)) a. WWI’s before-tax cost of debt is 4.73 4.73 Correct %. b. WWI’s cost of equity is 10.84 10.84 Incorrect %. c. WWI’s weighted average cost of capital is 6.91 6.91 Incorrect %
In: Finance
DEF Inc. is considering a project that will require an initial outlay of $750,000. DEF executives believe the project will provide an annual net cash flow of $150,000 per year for six years. What is the net present value of the project if the required rate of return is 10%?
A)18,536.78
B)-40,263.50
C)-96,710.90
D)110,623.82
In: Finance