An investment opportunity offers you an interest of 0.75% per month and paid monthly. What will...
Assume that you are looking at an investment opportunity that offers an annual operating cash flow of $40,000 per year for 4 years. The initial investment to purchase the necessary equipment is $200,000. You assume that you can sell the equipment at the end of 4 years for $70,000. Also, there is a need for an investment in net working capital of $15,000. If the required rate of return is 5%, and the tax rate is 35%, would you accept...
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...
Suppose you are offered an investment opportunity that will pay you $3136.72 per month for 49 months. To make this investment, you must invest a total of $125000, but only $12500 is in cash at the start. You must borrow the rest of the investment ($112500) from Lo-Rate Bank at 14.6% APR, with monthly compounding, and the entire loan must be repaid at the end of the 49 months in one lump sum, which will total $203470.77. To be clear,...
Suppose you are offered an investment opportunity that will pay you $5352.41 per month for 48 months. To make this investment, you must invest a total of $175000, but only $17500 is in cash at the start. You must borrow the rest of the investment ($157500) from Lo-Rate Bank at 18% APR, with monthly compounding, and the entire loan must be repaid at the end of the 48 months in one lump sum, which will total $321847.83. To be clear,...
a )A lender offers you a mortgage with an APR of 4.20% with monthly compounding. What is the effective rate of interest charged by the lender? b) An investor is considering an opportunity that pays the following cash flows: Year 1 2 3 Cash Flow $110.00 $132.00 $151.00 The investor thinks interest rates will rise over the next few years, so he wants to use different rates based on the year. For the first year, he will use a discount...
3. (1 pts) Suppose a mutual fund offers you an investment opportunity. For each $100 investment today, it will pay you $5 per year forever. The interest rate in the loanable funds market is 10%. You can inherit your investment or sell anytime. Would you invest? Why or why not? Show your work!
1) You plan to deposit $200 each month into an IRA earning 0.25% interest monthly. How much will you have in your account in 10 years? 2) You just graduated from college and landed your first "real" job, which pays $68,000 a year. In 9 years how much will you need to earn to maintain the same purchasing power if inflation is 0.75% per year? 3) Calculate the future value of $13,000 earning 9% for 35 years. 4) You have...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
You have $5,100 to deposit. Regency Bank offers 12 percent per year compounded monthly (1.0 percent per month), while King Bank offers 12 percent but will only compound annually.How much will your investment be worth in 18 years at each Bank? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Investment value Regency Bank $ King Bank $
An investment in a lease offers returns of $2900 per month due at the beginning of each month for three years. What investment is compounded semi-annually? tied the returns are deferred for two years and the interest required is 45 An investment of is justified Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed)