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

(Related to Checkpoint 18.2) (Calculating the cost of short-term financing) The R. Morin Construction Company needs to borrow $100,000 to help finance the cost of a new $150,000 hydraulic crane used in the firm's commercial construction business. The crane will pay for itself in one year, and the firm is considering the following alternatives for financing its purchase: Alternative A. The firm's bank has agreed to lend the $100,000 at a rate of 13 percent. Interest would be discounted, and a 16 percent compensating balance would be required. However, the compensating-balance requirement is not binding on the firm because it normally maintains a minimum demand deposit (checking account) balance of $25,000 in the bank. Alternative B. The equipment dealer has agreed to finance the equipment with a 1-year loan. The $100,000 loan requires payment of principal and interest totaling $117,390. a. Which alternative should Morin select? b. If the bank's compensating-balance requirement had…
Lulus Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $12,000,000 for the year. Lyssa Bickerson, staff analyst at Lulus, is preparing an analysis of the three projects under consideration by Caden Lulus, the company's owner. (Click the icon to view the data for the three projects.) Present Value of $1 table Present Value of Annuity of $1 table Future Value of $1 table Future Value of Annuity of $1 table Read the requirements. Requirement 1. Because the company's cash is limited, Lulus thinks the payback method should be used to choose between the capital budgeting projects. a. What are the benefits and limitations of using the payback method to choose between projects? Benefits of the payback method: O A. Easy to understand and captures uncertainty about expected cash flows in later years of a project O B. Utilizes the time value of money and computes each project's unique rate of return OC.…
Need all answer. ........
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
Assume you are the finance manager of Methanol Company, and the company is considering investing in one of the two projects. The life for both the Projects X and Project Y is 6 years. Project X costs OMR. 20500 and Project Y costs OMR.20500. The discount rate/cost of capital is 3.55%. 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.
Please use the images attached to answer the following:Determine the weighted average cost of capital (WACC) for VigourPharmaceuticals.
Use the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5.5.15.1.1 Calculate the Payback Period of Project A (expressed in years, months and days). INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%.
The city council of Morristown is considering the purchase of one new fire truck. The options are Truck X and Truck Y. The appropriate financial data are as follows (shown): The purchase is to be financed by money borrowed at 12% per year. Use this information to answer, What is the conventional B–C ratio for Truck X? (a) 1.41 (b) 0.87 (c) 1.64 (d) 1.10 (e) 1.15.
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
Use Excel to solve the following problem. Assume that as a local government financial analyst you are asked to project the feasibility of a loan to a proposed public service venture for its start-up funding. The venture’s principals estimate that, at the end of 5 years, they will be able to pay back up to $800,000 from revenues accruing to the venture’s activities. Assuming that your organization’s current “average cost of capital” is 4.8% (the “discount rate”). Assuming monthly compounding, what is the maximum amount your government can commit to the venture for its start-up? (I have worked this problem out on my own, I just want to be sure I used the correct formulas.)
Assume that as a local government financial analyst you are asked to project the feasibility of a loan to a proposed public service venture for its start-up funding. The venture’s principals estimate that, at the end of 5 years, they will be able to pay back up to $800,000 from revenues accruing to the venture’s activities. Assuming that your organization’s current “average cost of capital” is 4.8% (the “discount rate”). Assuming monthly compounding, what is the maximum amount your government can commit to the venture for its start-up?
Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 40,000 Year 2 56,000 Year 3 80,295 Year 4 90,400 Year 5 65,000 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 32,000 50,000 66,000 72,000 24,000

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