The finance team is looking at some various CD and savings options to create a sinkingfund to pay for a planned facility expansion. They are going to need $175,000 at the endof month 3, $160,000 at the end of month 4 and $120,000 at the end of month 6.Marinette has been working with 2 local banks; the following table outlines their currentreturn on various investments. (Blanks note that that option is not available at that bank.)ReturnTerm (months)Bank 1Bank 210.82%0.88%21.81%1.93%32.53%43.81%3.84%55.46%66.42%7.05%The 1-month investments noted in the table above each have a setup fee, Bank 1 has a$400 fee per investment, Bank 2 charges $600. This fee is charged at the beginning ofeach investment. Create an Excel model to determine the optimum solution to meet therequired payments.

https://docs.google.com/spreadsheets/d/1z1xxwU-D4FJFS1vZZKu33kCdT7qTM6Z1BGLtOBtvSoI/edit?usp=sharing…

Answered: The finance team is looking at some…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter10: Capital Budgeting: Decision Criteria And Real Option

Section: Chapter Questions

Problem 11P

See similar textbooks

Similar questions

Assume you are the finance manager of Almanor Company, and the company is considering investing in one of the three projects. The life for both the Projects X, M and Project Y is 5 years. Project X costs OMR. 20500, Project M costs OMR. 20500 and Project Y costs OMR.20500. The discount rate/cost of capital is 4.15%. Required: Use the following techniques to help company to decide which Machine is better and justify why? a) Payback period b) Discount payback period c) Net Present Value d) Present value index -Profitability index. Year Project X Project M Project Y 7865 3748 8752 4567 7609 8393 3. 9676 4628 4508 7292 8905 7836 9904 0066 8287 (Ctrl) - 45
You are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 13 percent. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Project X (Videotapesof the Weather Report)($28,000 Investment) Project Y (Slow-MotionReplays of Commercials)($48,000 Investment) Year Cash Flow Year Cash Flow 1 $ 14,000 1 $ 24,000 2 12,000 2 17,000 3 13,000 3 18,000 4 12,600 4 20,000 a. Calculate the profitability index for project X. (Do not round intermediate calculations and round your answer to 2 decimal places.) b. Calculate the profitability index for project Y. (Do not round intermediate calculations and round your answer to 2 decimal places.) c. Which project would you select based on the profitability index? multiple choice Project X Project Y
Can you use the images attached to calculate the initial cash flow of the project. PLease explain how it is calculated as well.
You are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 14 percent. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Project X (Videotapesof the Weather Report)($20,000 Investment) Project Y (Slow-MotionReplays of Commercials)($40,000 Investment) Year Cash Flow Year Cash Flow 1 $ 10,000 1 $ 20,000 2 8,000 2 13,000 3 9,000 3 14,000 4 8,600 4 16,000 a. Calculate the profitability index for project X. b. Calculate the profitability index for project Y.
Vencap Enterprises is evaluating an investment opportunity that will require contributions of $30,900 in Year 1 and $10,900 in Year 2. Returns of $29,000, $64,500, and $44,500 are expected in the three following years. a. What price should Vencap offer for the investment opportunity if it requires a 9.9% return on investment? (Do not round intermediate calculations and round your final answer to the nearest whole dollar amount.) Price %24
The Yurdone Corporation wants to set up a private cemetery business. According to the CFO, Barry M. Deep, business is "looking up." As a result, the cemetery project will provide a net cash inflow of $195,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 4 percent per year forever. The project requires an initial investment of $2.4 million. a-1. What is the NPV for the project if the company's required return is 11 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. NPV a-2. If the company requires an 11 percent return on such undertakings, should the cemetery business be started? No O Yes b. The company is somewhat unsure about the 4 percent growth rate assumption in its cash flows. At what constant growth rate would the company just break even if it still required a return of 11 percent on investment? Note: Do not round intermediate calculations and enter your answer as a percent…
Wilma is considering opening a widget factory. The unlevered cost of equity for making widgets is 0.1. This factory would cost $10 million to set up, and would produce EBIT of $3 million per year for the foreseeable future. She is thinking of applying for a $3 million subsidized perpetual loan to finance this project. Complying with the auditing requirements of this loan would have a present value of $2 million. This loan would have a rate of 0.04, while the rate she could get from the bank is 0.07. Her tax rate is 0.41. What is the NPV of this project, using the APV method?
An FI is planning the purchase of a $4 million loan to raise the existing average duration of its assets from 4.8 years to 6.3 years. It currently has total assets worth $20 million, $4 million in cash (0 duration), and $16 million in loans. All the loans are fairly priced. a-1. Assuming it uses the cash to purchase the loan, calculate the duration of the existing loan. a-2. Assuming the FI uses the cash to purchase the loan and that the loan has a 8.3 year duration, calculate the resulting duration of the asset portfolio. a-3. Should it purchase the loan if its duration is 8.3 years?b. What asset duration loans should it purchase in order to raise its average duration to 6.3 years?
The committee decided to secure a loan of $2,400,000 for the overall project. They got two offers from banks. - MC bank - pay in 24 months, $100,000 p/month of repayment, at an annual simple interest rate of 5% for the total loan - CS bank - pay in 16 months, $150,000 p/month of repayment at, an annual compound interest rate of 6% for the total loan The committee needs to decide which bank they should go with. So, they hired you as their financial advisor. 4. Create two amortization tables showing Payment number, Payment, Interest, Principal Reduction , Balance and total payments for Simple interest and Compound interest. 8. The city expects the population in the Residential Infrastructure area to grow exponentially at a rate of 2% per year. a. Calculate the projected population after 10 years if the current population is 50,000 (define a recurrence relation to answer this question). b. Draw a graph illustrating the population growth over 10 years. The city planning committee is…
The Yurdone Corporation wants to set up a private cemetery business. According to the CFO, Barry M. Deep, business is "looking up." As a result, the cemetery project will provide a net cash inflow of $94,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 3 percent per year forever. The project requires an initial investment of $1,470,000. a-1. What is the NPV for the project if the company's required return is 12 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPV a- If the company requires a return of 12 percent on such undertakings, should the 2. cemetery business be started? No O Yes b. The company is somewhat unsure about the assumption of a growth rate of 3 percent in its cash flows. At what constant growth rate would the company just break even if it still required a return of 12 percent on investment? (Do not round…
An investor is looking at building a factory to make gizmos. He estimates that it would cost $150,000 to build this factory from scratch. He reckons that his returns from the sale of gizmos would be $20,000 at the end of year 1, 35,000 in year 2, 40,000 in year 3, 60,000 in year 4 and 75,000 in year 5. The bank currently offers an interest rate of 8% on loans. The investor does his calculations and goes to present his proposal to the bank manager. Would the bank manager approve the loan? Why? Calculate the investor's exact MEC? Make sure to show every step in the calculations to get full marks. Round off to whole numbers.
An IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter the discounted costs and benefits for your project below. Add and delete rows as needed. Year Costs Benefits Cumulative Costs Cumulative Benefits 1 2 3 4

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

SEE MORE TEXTBOOKS