For the first 9 questions, you are allowed to use MS Excel for 30 minutes max....

Transcribed Image Text:

For the first 9 questions, you are allowed to use MS Excel for 30 minutes max. 1) Monthly payments of $300 are made at the beginning of each month on a lease having a book value of $15,050. What is the term of the lease if the lessee's cost of borrowing is 12% compounded monthly? A) 40 months B) 70 months C) 71 months D) 41 months E) 69 months NO OT 2), Today, Barry reached his 50th birthday and he has $70,000 in his retirement fund. His goal is to have $500,000 on his 65th birthday. He can expect his investments to earn 13% compounded semiannually. How much will he have to invest at the end of every six months for the next 15 years in order to reach his goal? A) $4,978.30 B) $428.30 C) $2,388.89 D) $1,722.84 E) $926.14 rinder Pal Singh 3) An $80,000 loan is amortized by monthly payments over 25 years. The interest rate charged is 10% compounded semiannually. What will the principal balance be after three years? A) $77,400.72 B) $65,965.72 C) $78,898.93 D) $76,532.48 E) $79,617.86 To what amount will investments of $2,500 at the beginning of every year for 32 years, earning 11% compounded monthly, accumulate by the end of the 32nd year? A) $216,558 B) $686,323 C) $856,230 D) $777,285 E) $578,114 ente For the first 9 questions, you are allowed to use MS Excel for 30 minutes max. 1) Monthly payments of $300 are made at the beginning of each month on a lease having a book value of $15,050. What is the term of the lease if the lessee's cost of borrowing is 12% compounded monthly? A) 40 months B) 70 months C) 71 months D) 41 months E) 69 months NO OT 2), Today, Barry reached his 50th birthday and he has $70,000 in his retirement fund. His goal is to have $500,000 on his 65th birthday. He can expect his investments to earn 13% compounded semiannually. How much will he have to invest at the end of every six months for the next 15 years in order to reach his goal? A) $4,978.30 B) $428.30 C) $2,388.89 D) $1,722.84 E) $926.14 rinder Pal Singh 3) An $80,000 loan is amortized by monthly payments over 25 years. The interest rate charged is 10% compounded semiannually. What will the principal balance be after three years? A) $77,400.72 B) $65,965.72 C) $78,898.93 D) $76,532.48 E) $79,617.86 To what amount will investments of $2,500 at the beginning of every year for 32 years, earning 11% compounded monthly, accumulate by the end of the 32nd year? A) $216,558 B) $686,323 C) $856,230 D) $777,285 E) $578,114 ente