Mike Macaro is selling a piece of land. Two offers are on the table. Morton Company offered a $48,000 down payment and $35,800 a year for the next 4 years. Flynn Company offered $29,000 down and $38,800 a year for the next 4 years. Assume money can be invested at 9% compounded annually. (Use Table 13.2.) a. What is the value of the offers? (Do not round intermediate calculations. Round your answers to the nearest cent.) Value Morton Company Flynn Company b. Which offer is better for Mike? Morton Company O Flynn Company

Please answer this question in a comprehensive and detailed manner with step by step solution. Reject any form of excel's sheet answer format. Just do it manually.

Your uncle offers you a choice of $106,000 in 10 years or $43,000 today. Use Appendix B as an approximate answer, but calculate your final answer using the formula and financial calculator methods. a-1. If money is discounted at 9 percent, what is the present value of the $106,000? (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Present value a-2. Which offer should you choose? $106,000 after 10 years O $43,000 today

You have been offered a contract from Comp Co. You will receive $120,000 up front from Comp Co. In exchange, you will provide $50,000 in services each year for 3 years. Your cost of capital is 10%. Find the NPV and IRR of the deal. Should you accept the contract? Explain.

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

7. What is the payback period? ?

Investment X offers to pay you $5,400 per year for 9 years, whereas Investment Y offers to pay you $7,500 per year for 5 years.   If the discount rate is 6 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)   If the discount rate is 21 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Bill Padley expects to invest $6,000 for 3 years, after which he wants to receive $6,945.60. What rate of interest must Padley earn? (PV of $1. EV of $1. PVA of $1. and EVA of $1) (Use appropriate factor(s) from the tables provided. Round "Table Factor" to 4 decimal places.) Future Value Present Value Table Factor Interest Rate %

What excel function do I use?  Or is there a equation? I tried referring to the other answer on bartleby but it is wrong

You agree to purchase a car with a competitive value of $44,500 for the following loan contract: Purchase the car for $44,250 with $2,000 down and borrow the remainder over 5 years with monthly payments based on a rate of interest of 6.6%.  Your market rate of return is 5.25%. How much value did you destroy with this purchase? (Round to dollars and cents; round the car payment to dollars and cents.)