A nurse borrowed P100, 000 to pay for the processing fee of her papers to work in the US. She borrowed from a financing company charging 10% compounded quarterly. The loan is to be amortized by quarterly payments for a term of one year. 1) How much is the quarterly payment?  2) Construct an amortization schedule for this loan

Q: Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan…

A: PV = $20,000r = 7% / 2 = 0.07 / 2 = 0.035 (semiannual interest rate)n = 5 years * 2 = 10 payments

Q: We will use Excel PMT function to calculate the payment Rand then create an amortization schedule…

A: PMT function in excel is used to calculate the amount of payment received or paid by the individual.…

Q: Farmer Ty needs to finance a machinery purchase of $70,000. His lender requires a down payment of…

A: Loan installment is that amount which is paid every month/ every year depend upon the terms which is…

Q: Anna received a loan of $29,000 at 4.5% compounded semi-annually. He had to make payments at the end…

A: Loan installment is that which is paid by borrower to lender for a specified period of time. This…

Q: Prepare an amortization schedule for a three-year loan of $111,000. The interest rate is 10 percent…

A: The problem case wants to create the loan amortization schedule for the loan that is to be repaid in…

Q: Georgia applied for a home mortgage of 75,000 to finance the purchase of a new home for 30 years.…

A: Loan amount (PV) = 75,000 Annual interest rate (r) = 14% Number of annual payment (n) = 30

Q: b) A man borrowed GH¢164,000 from a bank to help finance the purchase of a store. The bank charges…

A: Interest is the cost of borrowing money. It can be simple or compounded.

Q: Irene’s Home credit was approved. She will be borrowing ₱55,000 but abiding by the rules she will…

A: Amortization of Loan Amount: An amortized loan is one in which the borrower is required to make…

Q: A couple purchase a home and sign a mortgage contract for $150000 to be paid monthly over 25 years.…

A: a. Calculate the monthly payment as follows: Monthly payment is $1,157.72

Q: John Adams borrowed $25,000 at a 10% annual interest rate for a vehicle purchase from First  State…

A: solution given Amount of loan $25,000 Rate of interest 10% Payment Three equal end…

Q: b) You have decided to buy an apartment costing $140,000. At preseñt you have $10,000 to be paid as…

A: Answer : Cost of Apartment = $140,000 Down payment = $10,000   Loan = Cost of Apartment - Down…

Q: Hange Zoe borrowed money to upgrade their battle equipment of Survey Corps in the lending company in…

A: First obligation (L1) = P 225000 after 1 year r1 = 10% Second obligation (L2) = P 320000 after 2…

Q: ABC Realty sold a piece of land for P250,000. A down payment of P50,000 was made and the remainder…

A: Present Value of Loan = Present Value Factor x Cash Flow during the period

Q: A woman borrowed P3, 000, 000 to be paid after 1.5 years with interest at 12% compounded…

A: Solution:- When an amount is invested somewhere, it earns interest on it. The amount initially…

Q: n financing a new shopping center, the owner receives a loan of P1M at the beginning of each 6…

A: Deferred annuity refers to a contract payment wherein the account holder is promised to receive a…

Q: Find the monthly amortization of the loan.​

A: Monthly Amortization: It refers to the monthly payments made to the lender by the borrower for…

Q: 1. Mary made a loan of P58,000 to supply her new business. It is to be amortized by ten equal…

A: We need to use RATE function in excel to calculate interest rate. Formula is =RATE(NPER,-PMT,PV)

Q: a) Peter wishes to purchase a motor vehicle from a dealer in Johannesburg for R150 000. His bank,…

A: We will use excel function 'PMT' to find the monthly payment for the loan. as shown in the above…

Q: FIND THE MONTHLY AMORTIZATION(A) FOR PERIOD 1, THE INTEREST(B) FOR PERIOD 5, THE PRINCIPAL(C) FOR…

A: Loan amount = Price of the house  - down payment = 2,200,000 - 15% of 2,200,000 = 2,200,000 -…

Q: Crystal secured a lease on a machine by paying $1,800 as a down payment and then $275 at the…

A: Present value of lease payments is principle amount of loan  loan amount plus down payment is cost…

Q: An employee obtained a loan of P100,000.00 at the rate of 6% compounded annually in order to build a…

A: The series of monthly payments is a form of annuity wherein an equal amount is paid every month.

Q: A nurse borrowed P100, 000 to pay for the processing fee of her papers to work in the US. She…

A: Loans refer to contracts between parties where money is forwarded by one party to the other on the…

Q: A design studio received a loan of $6,800 at 4.10% compounded semi-annually to purchase a camera. If…

A: The borrower who has received cash or money from a lender is known as the loan holder. The borrower…

Q: Suppose you are a relationship manager at an international bank. A customer who recently got…

A: To create the amortization table, first we will have to find the EMI. To find the EMI, we will use…

Q: U.S. Fax has been granted a loan from a commercial finance company for $1 million at a stated…

A: Effective Cost of Debt(ECD) refers to the total amount that is paid by borrower to lender for taking…

Q: The Flemings secured a bank loan of $272,000 to help finance the purchase of a house. The bank…

A: Amount of loan "P" is $272,000 Interest rate is 4% per year Monthly interest rate "r" is…

Q: en problem. Problem: Mrs Talla obtained a loan of P200,000. She has to repay the loan by equal…

A: The given problem can be solved using PMT function in excel. PMT function computes installment…

Q: Suppose a graduate student receives a non-subsidized student loan of $11,000 for each of the 4 years…

A: Non-Subsidized Student Loan per year = $11,000 Time Period of Non-Subsidized Student Loan = 4 Years…

Q: and you cannot cancel on the due date, so you must cancel with a delay of 25 days, it is requested:…

A: Interest is the fee paid to a lender for using the funds. It is the compensation paid to an investor…

Q: Ryan must pay off a loan of $4,000 in 3 years. Use the appropriate formula to find the amortization…

A: Amortization: When the debt is paid off in regular installments and principal of loan is repaid till…

Q: The Flemings secured a bank loan of $328,000 to help finance the purchase of a house. The bank…

A: Ordinary annuities are the PMTs which are made at the end of the period.

Q: Jesse received a loan of $36,000 at 5.75% coumpounded quarterly. She had to make payments at the end…

A: The payment size for a loan refers to the installment amount which is paid by loan taker in each…

Q: To travel to America via the ship Titanic, Juana made a P100,000 loan which is to be paid over a…

A: A sinking fund refers to the amount that is kept for the payment of debt raised at the time of…

Q: An engineer wished to purchase an $80,000 home by making a down payment of $20,000 and borrowing the…

A: Bank fees are any charges made by financial institutions to their individual and commercial…

Calculating the Return On A Loan