Maria is considering purchase of a new machine. The purchase price of the machine is $12,000. The vendor agreed payments in installments at an interest rate of 15% compounded quarterly over 4 years. What will Maria’s quarterly installments be? Show calculation using Excel.

Maria is considering purchase of a new machine. The purchase price of the machine is $12,000. The vendor agreed payments in installments at an interest rate of 15% compounded quarterly over 4 years. What will Maria’s quarterly installments be? Show calculation using Excel.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 9P

See similar textbooks

Related questions

Q: John Doe has just been offered a home loan towards purchase of house that is being sold for…

A: Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…

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: Assume that you can get a loan from NCB for $264,500 for three years to buy an item of your…

A: Present Value of Ordinary Annuity refers to the concept which dictates the discounted value of a sum…

Q: A $300,000 mortgage at 5.8% compounded semiannually requires monthly payments that were calculated…

A: Loan amount (L) = $300000 Interest rate = 5.8% semiannually compounded n = 25 years = 300 payments…

Q: The cost of the book is P1,000,000 which will amortized for 3 years monthly but he will start paying…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: What monthly payment will she be required to make if the car is financed over a period of 24 months?…

A: Loan Monthly Payments: These are payments made by the borrower to the lender for the purpose of…

Q: Tina purchases a new computer by financing it on the "no payment until next year" plan. The cash…

A: Nominal interest rate is referred to as an interest rate before considering the inflation on an…

Q: machine selling for $10000 may be purchase by paying a $1000 deposit and the balance in equal…

A: in this problem we have to calculate present value FACTOR and from that we can get monthly payments.

Q: In order to purchase another truck, Beatty Transport recently obtained a $125,000 loan for five…

A: Given Information:Loan amount is $125,000 Number of years is 5 Interest rate is 7.8% (semi-annual)

Q: Robert bought a photocopying machine on an installment basis with 15, 103 downpayment and 84 monthly…

A: Present Value(PV) is current value of any future amount. It is calculated by discounting that future…

Q: Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller…

A: If it had been normal payments we would have used the simple formula. However, since there is a…

Q: A car was bought on an installment basis with a monthly installment of 30,000 for 60 months. If the…

A: Monthly payment (P) = $ 30,000 Number of monthly payments (N) = 60 Annual interest rate = 12%…

Q: TA Corp. has a consulting contract with a firm that states that he will receive annual payments of…

A: We need to use present value of annuity due(payment due at beginning of year) formula for…

Q: The Sandersons are planning to refinance their home. The outstanding principal on their original…

A: Outstanding principal (P) = $110000 n = 240 months Initial interest rate = r = 5% per annum =…

Q: Mary Jones recently obtained an equipment loan from a local bank. Theloan is for $15,000 with a…

A: Given information: Loan amount is $15,000 Nominal interest rate is 11% Loan repayment in 1 year

Q: A car can be purchased with monthly installments of 8,500 and a down-payment of 115,000 for 48…

A: Monthly installment (M) = 8500 Down payment (D) = 115000 n = 48 months r = 12% per annum = 1% per…

Q: Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller…

A: We use pmt function in excel to solve the problem

Q: You buy a lathe for $10,000. You are charged an annual interest rate of 12% and pay equal quarterly…

A: Loan = 10,000 Interest rate = 12%/4 = 3% per quarter N = 20*4 = 80 Quarters

Q: Niagular Corp. needs to take out a one-year bank loan of $450,000 and has been offered loan terms by…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: yesterday, Ahmed Ali borrowed $87000 to purchase Bulldozer. He can repay the loan in either of the…

A: The money available at time 0 or at present, is referred to as present worth or present value. The…

Q: A house that sells for P900,000 can be purchased under terms requiring 100 monthly payments. Assume…

A: Given that;Present value is P900,000Number of periods is 100

Q: The Sandersons are planning to refinance their home. The outstanding principal on their original…

A: First, we need to find the current instalment which is given by Loan amount = PV of all instalments…

Q: The price of a new car is $36,000. Assume that an individual makes a down payment of 25% toward the…

A: The loan which is paid-off by making installment payments having two components as interest mount…

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: Kyle was supposed to pay Erin $6,700 6 months ago and $720 in 5 months. If he wants to repay this…

Q: A man intends to buy a machine via loan. He does so by depositing a down payment followed by…

A: In this we need to find present value of both and from that we can get initial deposit.

Q: How much less can they expect to pay over the life of the loan in interest payments by refinancing…

A: Information Provided: Original Loan = $110,000 N = 267 First Interest rate = 11%/year compounded…

Q: Excellent bank has offered you $40,000, 30-year loan to purchase an equipment in your Factory. The…

A: A = P1+r100n Where A = Amount P = Principal r = Rate of interest n = Number of periods

Q: Susan Bentley will purchase a home for $257,000. She will use a down payment of 20% and finance the…

A: Installment is the amount of periodic payments a borrower makes to its lender in order to pay back…

Q: A motorcycle is for sale for ₱ 60,500 in cash or on installment terms for ₱ 3,000 per month for 2…

A: Cash value = P 60,500 Monthly payment (P) = P 3000 Period = 2 Years Monthly period (n) = 2*12 = 24…

Q: The price of a new car is $36,000. Assume that an individual makes a down payment of 25% toward the…

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

Q: The Taylors have purchased a $150,000 house. They made an initial down payment of $20,000 and…

A: Monthly payment for the loan can be calculated using the formula of present value of annuity

Q: The price of a new car is $40,000. Assume that an individual makes a down payment of 25% toward the…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Mr. Jimin borrowed money to CBA Bank for $211,000 for business development the chicken farm. The…

A: Given, Loan Amount - 211,000 Interest rate = 9% (compounded monthly) Period - 12 years

Q: Miguel purchased a hot tub costing $5,030 by taking out an installment loan. He made a down payment…

A: Monthly payments interest rate is calculated by excel function RATE, where the inputs are: pv:…

Q: The price of a new car is $32,000. Assume that an individual makes a down payment of 25% toward the…

A: Cost of car = $32,000 Down Payment = 25% Interest Rate = 6% compounded monthly Loan amount = Cost…

Q: 2: An engineer wishes to purchase an $80 ayment of $20 000 and borrowing the remaining $60 000,…

A: In this question payment per month needs to be find out. Loan amount is $60,000 and it is to be paid…

Q: Suppose you are thinking of availing a loan of P100,000 at Pag-ibig Funds for house repairs after…

A: A loan refers to the borrowed amount taken by a person from the lender in case of a shortfall of…

Q: Assume that you will have a 10-year, $20,000 loan to repay when you graduate from college next…

A: Note: As per the Policy, We’ll answer the first question since the exact one wasn’t specified.…

Q: A building is priced at $300,000. If a buyer makes a down payment of $100,000 and a payment of…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: For my newly purchased car, I have to pay five year-end installments of P250,000 each year for the…

A: Year end installment = P 250,000 Second year maintenance cost = P 10,000 Annual increase in…

Q: In 4 years, Jennifer Videtto will need to purchase a delivery van for her plumbing company. She…

A: Present value refers to the current value of future stream of cash flows at a given specified rate…

Q: If you buy a computer directly from the manufacturer for $2,241 and agree to repay it in 48equal…

A: Using Excel PMT function.

Q: he price of a new car is $16,000. Assume that an individual makes a down payment of 25% toward the…

A: Repayment of loan is made in fixed amount of instalments which includes interest and part of…

Q: Tedros borrowed $2 million and planned to repay the loan by making equal month-end payments over a…

A: A financial measurement that calculates the worth of a potential sum of money or stream of payments…

Concept explainers

Amortized Loans

The term "amortization" refers to spreading the value of a loan or a debt over a series of regular payments or installments comprising of both the principal and interest amount. It generally involves the process where in the value of a loan or an intangible asset is written down over its maturity period.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1 As per the question

VIEW

Step 2 Solution

VIEW

Step 3 Answer

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Electro Corporation bought a new machine and agreed to pay for it in equal annual installments of 5,000 at the end of each of the next 5 years. Assume a prevailing interest rate of 15%. The present value of an ordinary annuity of 1 at 15% for 5 periods is 3.35. The future amount of an ordinary annuity of 1 at 15% for 5 periods is 6.74. The present value of 1 at 15% for 5 periods is 0.5. How much should Electro record as the cost of the machine? a. 12,500 b. 16,750 c. 25,000 d. 33,700
Using the information provided, what transaction represents the best application of the present value of an annuity due of $1? A. Falcon Products leases an office building for 8 years with annual lease payments of $100,000 to be made at the beginning of each year. B. Compass, Inc., signs a note of $32,000, which requires the company to pay back the principal plus interest in four years. C. Bahwat Company plans to deposit a lump sum of $100.000 for the construction of a solar farm In 4 years. D. NYC Industries leases a car for 4 yearly annual lease payments of $12,000, where payments are made at the end of each year.
Next Level Potter wishes to deposit a sum that at 12% interest, compounded semiannually, will permit 2 withdrawals: 40,000 at the end of 4 years and 50,000 at the end of 10 years. Analyze the problem to determine the required deposit, stating the procedure to follow and the tables to use in developing the solution.
If Bergen Air Systems takes out a $100,000 loan, with eight equal principal payments due over the next eight years, how much will be accounted for as a current portion of a noncurrent note payable each year?
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Del Hawley, owner of Hawleys Hardware, is negotiating with First City Bank for a 1-year loan of 50,000. First City has offered Hawley the alternatives listed here. Calculate the effective annual interest rate for each alternative. Which alternative has the lowest effective annual interest rate? a. A 12% annual rate on a simple interest loan, with no compensating balance required and interest due at the end of the year b. A 9% annual rate on a simple interest loan, with a 20% compensating balance required and interest due at the end of the year c. An 8.75% annual rate on a discounted loan, with a 15% compensating balance d. Interest figured as 8% of the 50,000 amount, payable at the end of the year, but with the loan amount repayable in monthly installments during the year