38)

A)Using a handheld (5 button) financial calculator, compute the size of the first payment of a car loan. More specifically, youll borrow $25,141 today at an APR of 11%. There will be a total of 31 equally-sized (g = 0), monthly payments with the first payment due in one month.

B)Using a handheld (5 button) financial calculator, compute the size of the first payment of a car loan. More specifically, youll borrow $18,879 today at an APR of 6%. There will be a total of 47 equally-sized (g = 0), monthly payments with the first payment due immediately.

C)Lets rework A (with different numbers), using Excel. Lets redo letter A first, which (with new numbers), is: ...

Use Excels " =PMT( ) " command to compute the size of the first payment of a traditional car loan.

More specifically, youll borrow $10,563 today at an APR of 8%. There will be a total of 31 equally-sized (g = 0), monthly payments with the first payment due in one month.

D)Now lets redo B, using Excel, with new numbers:

Compute the size of the first payment of a car loan.

More specifically, youll borrow $11,520 today at an APR of 10%. There will be a total of 60 equally-sized (g = 0), monthly payments with the first payment due immediately.

E) Use Excels PV command, to answer the following question.

Youre due to receive 17 equally-sized (g = 0), annual payments, each of size $567. The first payment will be received in 1 year. The effective annual discount rate is 8.9%. Determine the present value.

F)Use Excels PV command to answer the following question.

Youre due to receive a total of 8 equally-sized annual payments, each of size $225. The first payment will be received immediately. The effective annual discount rate is 10.7%. Determine the present value.

G) Use Excels NPV command to determine the present value of the following mixed-set of cash flows.

Youll pay $-1,700 immediately (i.e. a negative cash flow). Thereafter, at the end of the 5th year youll receive a single payment of $682. Thereafter, once again, youll receive nothing for a while. Then 12 years from today, youll begin to receive payments from an annuity stream. The first payment will be $285. The last payment will be received 22 years from today. The payments that comprise the annuity stream are all of the same magnitude (g = 0).

Using an effective annual discount rate (EAR) of 10.1%, determine the present value of the entire set of cash flows.