Joshua borrows 35,000 pesos from a cooperative to buy a laptop. He will repay the loan in equal monthly payments over 2 years at the end of each month. If he is charged 10% interest compounded monthly, how much is his monthly payment? What is the total amount that he repays? (step-by-step solution, I can't understand excel)

Joshua borrows 35,000 pesos from a cooperative to buy a laptop. He will repay the loan in equal monthly payments over 2 years at the end of each month. If he is charged 10% interest compounded monthly, how much is his monthly payment? What is the total amount that he repays? (step-by-step solution, I can't understand excel)

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 25PROB

See similar textbooks

Similar questions

William borrows $22,000 to buy a car. He will repay the loan through 4 years of equal monthly payments and an annualized interest rate of 4.3%. Think about payment #32 of the loan obligation. How much of this payment will be principal? Enter your answer as a positive number (in dollars), and round to the nearest dollar.
Sean needs $18,000 immediately as a down payment on a new home. He can borrow this money from his company credit union. He will be required to repay the loan in equal payments made every six months, starting two years from now, over the next 5 years. The annual interest rate is 10%. Draw a cash flow diagram in the point of view of Sean. How many equal payments should be made? USING MANUAL COMPUTATION NO EXCEL
A student borrows $2500 from his uncle in order to finish school. His uncle agrees to charge him simple interest at the rate of 3.7% per year. Suppose that the student waits 3.7 years and then repays the entire loan. How much interest will he have to pay?
George borrows $43,000 to buy a car. He will repay the loan through 4 years of equal monthly payments and an annualized interest rate of 3.9%. Think about payment #44 of the loan obligation. How much of this payment will be interest? Enter your answer as a positive number (in dollars), and round to the nearest dollar.
You loaned your brother a substantial amount of money and are working out a payment system. You’ve mutually agreed to a repayment schedule of $400 per month. You will charge 1 percent per month interest on the overdue amount. If the current balance is $20,000, how long will it take for the account to be paid off?
2. Alex needs to repay a $ 8500 debt. His bank offers personal loans with terms from one to five years at 8.9% per year, compounded monthly. a) Determine Alex's monthly payment for a five-year term. Use formula and show your work. ( gag. b) Calculate the total interest paid on the loan if he makes monthly payment. c) Determine Alex's payment if he chooses to make bi-weekly and weekly payments. Use TVM Advanced Calculator and fill up the blank. Bi-weekly Weekly TVM Advanced Calculator TVM Advanced Calculator Mode *End O Beginning Mode End Beginning Present Value PV Present Value PV Payments PMT Payments PMT
A student borrows $3000 from his uncle in order to finish school. His uncle agrees to charge him simple interest at the rate of 5.5% per year. Suppose the student waits two years and then repays the entire loan. How much will he have to repay?
Jessica wants to accumulate $13,000 by the end of 6 years in a special bank account, which she had opened for this purpose. To achieve this goal, Jessica plans to deposit a fixed sum of money into the account at the end of the month over the 6-year period. If the bank pays interest at the rate of 5% per year compounded monthly, how much does she have to deposit each month into her account? (Round your answer to the nearest cent.)
A man borrows $60,000 to help pay for his college expenses. He intends to pay off the loan with regular monthly payments over the next 20 years. Find the monthly payment if he is being charged 4.7% interest per year, compounded monthly. Give the answer to 2 decimal places, and do not use the $ sign in the answer box. The monthly payment is Blank 1. Calculate the answer by read surrounding text. dollars.
Can you please help me work out this problem in detail? Tony Ring wants to attend Northeast College. He will need $60,000 4 years from today. Assume Tony’s bank pays 6% interest compounded semiannually. What must he deposit today so he will have $60,000 in 4 years?
Rebecca Carlson purchases a car for $25,000 and finances her purchase by borrowing the money at 8% per year compounded monthly; she pays off the loan with equal monthly payments for 5 years. What will be the size of her monthly loan payment?
Mr. Nina borrows $425,000 from the bank at 3.5% per year interest over a 30-year period. He can make a monthly month-end payment of $1,400 and would like to make a balloon payment at the end of the 30-year period. What would be the size of the balloon payment? $218,058 $323,069 $433,197 $548,512 Please show how to work this out in Excel if possible?