Question

Problem 2 [20p]: A company offers the following two options to sell a car: Option 1: you do not have to make any payments for(F/P,i,n) = (1 + i) (P/A.i.n)- (1 + i) - 1 i(1 + i) (F/A,1,n) = (1 + i) – 1 (P/G,1,n)= (1 DICE _(1 + i) - in - 1 if (1 +

Solve without Using excel/Matlab.
solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by assuming each cash flow as a single cash flow at its corresponding year))

0 0
Add a comment Improve this question Transcribed image text
Answer #1

OPTION1:

Uniform Series Present Worth Factor (USPWF)=(P/A,i,n)=(((1+i)^n)-1)/(i*((1+i)^n))

i=Monthly interest rate =30/12=2.5%=0.025

n=Number of months of payment=2*12=24

USPWF=(P/A,2.5%,24)=((1.025^24)-1)/(0.025*(1.025^24))=17.88499

Present Value of cash flow at end of Month 5=3000*USPWF=3000*17.88499=53654.96

Present Value NOW=53654/((1+i)^n)

n=5, i=0.025

Present Value NOW=53654/((1.025^5)=47423.16

OPTION 2:

i=2.5%=0.025

n=24

USPWF=(P/A,i,n)=(P/A,2.5%,24)=17.88499

Present Value of Cash flow now=1000*17.88499=17884.99

BETTER OPTION:

OPTION 2

CASH FLOW DIAGRAM: OPTION 1 Month Cash Flow 0 -47423.16 2 6 3,000 7 3,000 8 3,000 93,000 10 3,000 11 3,000 12 3,000 13 3,000CASH FLOW-OPTION-1 10000 023 LLLLLLLLLLLLLLLLLLLLLLLLL 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29CASH FLOW DIAGRAM: OPTION 2 Month Cash Flow 0 -17884.99 1 1000 2 1,000 3 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10 1,000 1CASH FLOW-OPTION-2 5000 LLLLLLLLLLLLLLLLLLLLL 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 1 23 24 25 -5000 -10000

Add a comment
Know the answer?
Add Answer to:
Solve without Using excel/Matlab. solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • USE THE GIVEN FORMULAS WHENEVER POSSIBLE, NO Matlab or Excel solution You invest $1000 per month...

    USE THE GIVEN FORMULAS WHENEVER POSSIBLE, NO Matlab or Excel solution You invest $1000 per month for 9 months starting 4 months from now (i.e., from month 4 to month 12), and then you increase your investment by $100 per month for 2 years (i.e., from month 13 to month 36). If the rate of return is 60% per year, what is the equivalent annual worth ($ per year) of this cash flow in years 1 to 3? (F/P.1,6)= (1...

  • 3000 3000 3000 3000 3000 2250 1688 1266 949 712 534 0 1 2 3 4...

    3000 3000 3000 3000 3000 2250 1688 1266 949 712 534 0 1 2 3 4 5 6 7 8 9 10 Solve without Using excel/Matlab. solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by assuming each cash flow as a single cash flow at its corresponding year)) Problem 3 [20p]: A cash flow the attached diagram (where years). If the interest rate is 18% calculate the uniform series equivale A cash flow over 10 years is...

  • *Note: You should form cash flow diagrams and use excel functions to solve following questions. You...

    *Note: You should form cash flow diagrams and use excel functions to solve following questions. You should upload your excel files on blackboard and attach the hard copy of them to your HW. Q1: The present worth of the cash flow shown below at į= 10% is? 8 show the formula in excel step by step P ? 0 1 2 3 456 7 A $13,000 Q2: An engineering company in Wyoming that owns 50 hectares of valuable land has...

  • Edit: Please do not use Excel as I need to learn to solve without it. thank...

    Edit: Please do not use Excel as I need to learn to solve without it. thank you. Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...

  • This must be done on excel using formulas. I understand option 1 however for option 2...

    This must be done on excel using formulas. I understand option 1 however for option 2 and 3 I don't know how to get the PV factor percentage in order for me to complete the problem. E26-23 Using the time value of money Congratulations! You have won a state lottery. The state lottery offers you the follow- ing (after-tax) payout options: Option #1: Option #2: Option #3: $12,000,000 after five years $2,150,000 per year for five years $10,000,000 after three...

  • Using excel formulas, refer to the accompanying cash‐flow diagram and solve for the unknown quantity in...

    Using excel formulas, refer to the accompanying cash‐flow diagram and solve for the unknown quantity in Parts (a) through (d) that makes the equivalent value of cash outflows equal to the equivalent value of the cash inflow, a) If F=$10,000, G=$600, and N=6, then i=? b) If F=$10,000, G=$600, and i=5% per period, then N=? c) If G=$1,000, N=12, and i=10% per period, then F=? d) If F=$8,000, N=6, and i=10% per period, then G=?

  • Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use...

    Solve the problems below using well-formatted Excel solutions. Do not hardcode numbers in the formulas…..only use cell references to the input data. I will change the input data in your problem to check alternate solutions. You will turn in a complete working Excel spreadsheet with your solution. Given the following set of cash flows: Period Cash Flow 1 $            40,000 2 $            35,000 3 $            30,000 4 $            25,000 5 $            20,000 6 $            15,000 7 $            10,000 8 $               5,000 1. If your required rate of return...

  • please solve without excel 2. Suppose you are in the market for a new car worth...

    please solve without excel 2. Suppose you are in the market for a new car worth $35,000. You are offered a deal to make a 15% down payment now and to pay the balance in equal end-of-month payments over 60 months with an APR of 12%. a. What should be the required monthly payment? b. Complete the following table: End of Month Interest Payment Principle Payment Remaining Balance 31 $114 42 49

  • 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...

    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...

  • Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs...

    Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs (ie. N, PV, etc.) to get partial credit. 1. How much would you pay for the right to receive $12,000 at the end of 15 years if you can earn a 15% return on a real estate investment with similar risk? 2. What constant amount invested at the end of each year at a 10% annual interest rate will be worth $20,000 at the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT