Your brother's garden supplies business obtained a 30-year amortized mortgage loan for $250,000 at anominal annual rate (APR) of 7.0%, with 360 end-of-month payments. What is his monthly loan payment? What is the balance on his loan at the end of the first month? Please show work in excel

Your brother's garden supplies business obtained a 30-year amortized mortgage loan for $250,000 at anominal annual rate (APR) of 7.0%, with 360 end-of-month payments. What is his monthly loan payment? What is the balance on his loan at the end of the first month? Please show work in excel

CONCEPTS IN FED.TAX.,2020-W/ACCESS

20th Edition

ISBN:9780357110362

Author:Murphy

Publisher:Murphy

Chapter5: Introduction To Business Expenses

Section: Chapter Questions

Problem 61P

See similar textbooks

Related questions

Q: Karen takes an 8-year car loan of $50,000 at 2.14%, compounded monthly. If the payments are done at…

A: Monthly Compounding Loan Amount = 50,000 Time Period of loan = 8 years or 96 months Interest rate =…

Q: Miss Clare Jarrett just closed a loan of $400 000 to assist with the purchase of equipment and…

A: Loan Amount = $400,000 Time Period = 5 Years Interest Rate = 8%

Q: Mae purchased a home for ₱4,570,000 and obtained a 20-year loan with an annual interest rate of…

A: Given Information : Cost of home = 4,570,000 pesos Period of loan = 20 years Annual interest rate =…

Q: Leslie borrowed $25,000 at a rate of 6% compounded monthly (j12) for a term of 10 years. Calculate…

A: The loan is repaid in equal monthly instalments. Each instalment has interest and a portion of the…

Q: An engineer plans to borrow $100,000 to open his own consulting business. He must repay $2,150 a…

A: using financial calculator, N = 5*12 =60 PMT = -2150 PV= 100,000 FV = 0

Q: Justin is financing S169,600 for a home at 5.25% interest with a 25-year fixed-rate loan. Find the…

A: Using excel pmt function

Q: Carter bought a new car and financed $⁢25,000 to make the purchase. He financed the car for 60…

A: Loan amount (PV) = $ 25000 Interest rate = 5.5% Monthly interest rate (r) =…

Q: A man buys a house for $350,000. He makes a $150,000 down payment and amortizes The rest of the…

A: Price of house = $350,000 Down payment = $150,000 Mortgage amount = $350,000 -$150,000 Mortgage…

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: If Rochelle obtained a business loan of $205,000.00 at 4.67% compounded semi-annually, how much…

A: Business loan = $205,000.00 Interest Rate = 4.67% compounded semi-annually Time Period = 30 Years

Q: Jeffrey Wei received a 6 year non-subsidized student loan of $30,000 at an annual interest rate of…

A: Present Value = $30,000 Interest Rate = 5.9% Time Period= 6 Years Loan Start after 4 Years

Q: A couple purchased a home and signed a mortgage contract for $500, 000 to be paid with half-yearly…

A: Mortgage is a value which is borrowed from the other sources like banks to arrange the funds and…

Q: Matt purchased a car for 22,000 he paid 4400 as a down payment and financed the balance at 3.7%…

A: given, price of car = 22000 downpayment = 4400 r=3.7% m=12 (monthly compounding) n=5 years

Q: Dominic Torreto borrows $300,000 from a lending company in his hometown at 12% interest compounded…

A: Loan Amount = $300,000 Interest rate = 12% Time Period = 6 Months

Q: Tim Houston purchased a wall unit for $2,400. He made a $600 down payment and financed the balance…

A: The yearly rate that borrower pays on loan and investors receives on deposits is the annual…

Q: James received a 15 year loan of $230,000 to purchase a house. The interest rate on the loan was…

A: Working Note #1 Loan amount ($) 230000 N (years) 15 Period 180 Rate(Compounded annually)…

Q: Sergio purchased a house for $440,000; he paid $44000 as a down payment and financed the balance…

A: NOTE: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts…

Q: Allison purchased a house for $350,000. She made a downpayment of 30% of the value of the house and…

A: Given: Particulars Amount Cost of house $350,000 Down payment 30% Interest rate 6.50%…

Q: Juan took out a $20,000 loan for 146 days and was charged simple interest. The total interest he…

A: We need to use simple interest formula to solve this problem Simple interest =Principal*Rate*Time

Q: Marcel Thiessen purchased a home for $205,600 and obtained a 15-year, fixed-rate mortgage at 7%…

A: Interest part is the amount of interest payable on outstanding loan balance and principal repayment…

Q: Peggy made a down payment of $400 toward the purchase of new furniture. To pay the balance of the…

A: Purchase price of the furniture is present value of monthly payments plus down payments

Q: On January 1, 2018, Jimbo Enterprises purchased new equipment for its training center. The…

A: Following are the calculation of total interest expense will pay over the life of loan:

Q: You have borrowed $130,000 to buy a new motor home. Your loan is to be repaid over 15 years at 8%…

A: Therefore, the principal amount paid in month 2 is $378.19.

Q: Sean Lee purchases $40,000 worth of supplies for his restaurant by making a $3,000 down payment and…

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

Q: Jeffrey received a $32,950 loan from a bank that was charging interest at 5.75% compounded…

A: Amortized Loan: Amortized loan is a type of loan in which the borrower would pay periodic payments…

Q: A civil engineering student borrowed P40,000 to meet college expenses during his senior year. He…

A: We need to find the future value at the end of 3 years then use pmt function to calculate equated…

Q: Nelson took out a 25-year home loan of $500,000. He made equal month-end repayments at the interest…

A: A loan is a borrowing that is taken by an individual or a corporation from a bank or financial…

Q: Victoria buys a property for $2,500,000 by paying $500,000 down payment and the rest on a 15-year…

A: The amount taken on credit or financed by the person is ascertained by deducting the down-payment…

Q: Doris purchased a Steinway concert piano for $132,000 with a down payment of 25%, and a loan for the…

A: Cost of piano is $132,000 Down payment is 25% Equal Monthly Payment is $1,650 Interest rate…

Q: Matthew has a $32,500 student loan at 4.80% compounded quarterly amortized over 12 years with…

A: monthly interest rate = (1+quarterly rate)^(1/3) -1 = (1+4.80%/4)^(1/3) -1 =…

Q: Stacey purchased a car for $58,300; she paid 5% of the cost as a down payment and finance he balance…

A: The loans are paid equal end of the period payments and these periodic payments carry the payment…

Q: principal balance at the end of the first year, prior to make the lump sum payment? b. By how much…

A: The amortization period refers to the time taken to pay off the full loan amount on the basis of…

Q: An employee obtained a loan of P486,555 at the rate of 20.774% compounded bimonthly to build a…

A: Loan amount is P486,555 Interest rate is 20.774% Compounded bimonthly To Find: Nominal rate…

Q: Carlos purchased a house for $230,000; he paid $11500 as a down payment and financed the balance…

A: Value of House is $230,000 Down Payment is $11,500 Therefore, Loan Amount is : =$230,000-$11,500…

Q: Gabrielle obtained a business loan of $245,000.00 at 4.03% compounded semi-annually, how much should…

A: Loans are paid by the periodic payments that carry the payment for interest and payment for…

Q: xandra received a 30 year loan of $280,000 to purchase a he the loan was 4.60% compounded…

A: Loans are paid by the equal monthly payments and these monthly payments carry the payment for…

Q: Samuel Ng received a 3-year subsidized student loan of $12,000 at an annual interest rate of 5%.…

A: Computation of monthly loan payments:

Q: Morgan received a $29,050 loan from a bank that was charging interest at 3.25% compounded…

A: Loan is the value or an amount which is borrowed from other sources like banks for a finite period…

Q: A couple who borrow $70,000 for 15 years at 8.4%, compounded monthly, must make monthly payments of…

A: formula for remaining balance: remaining balance=princial×1+rmn-pmt×1+rmn-1rm where, r = rate of…

Q: John obtained a loan of $25,000 at 4.6% compounded monthly. How long (rounded up to the next payment…

A: Loan amount = $25,000 Interest rate = 4.6% Monthly payment = $2,810

Q: Jason received a 10-year non-subsidized loan of $40,000 at an annual interest rate of 6%. What are…

A: Loan amount refers to the amount that is borrowed by the borrower for fixed time period at fixed…

Q: Lisa has a $37,500 student loan at 3.15% compounded quarterly amortized over 16 years with payments…

A: Interest refers to the amount charged by the lender on the lent amount. The borrower of the loan is…

Q: An employee obtained a loan of P10,000 at the rate of 6% compounded annually in order to repair a…

A: Loan amount (PV) = P10,000 Interest rate = 6% Monthly interest rate (r) = [1+0.06]1/12 -1…

Q: When Florio and Rhoda bought their home, they borrowed $200,000 for 30 years at 6%, compounded…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: Quentin Satham borrows $500,000 from a lending company in his hometown at 12% interest compounded…

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

Q: A student takes out a loan for $40,000 and loan repayment is to begin after 6 years. Interest during…

A: Here, Loan Amount is $40,000 Interest Rate is 3% Compounding Period is Monthly i.e 12 Repayment of…

Concept explainers

Mortgages

A mortgage is a formal agreement in which a bank or other financial institution lends cash at interest in return for assuming the title to the debtor's property, on the condition that the obligation is paid in full.

Mortgage

The term "mortgage" is a type of loan that a borrower takes to maintain his house or any form of assets and he agrees to return the amount in a particular period of time to the lender usually in a series of regular equally monthly, quarterly, or half-yearly payments.

Question

Your brother's garden supplies business obtained a 30-year amortized mortgage loan for $250,000 at anominal annual rate (APR) of 7.0%, with 360 end-of-month payments.

What is his monthly loan payment?

What is the balance on his loan at the end of the first month?

Please show work in excel

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 2 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

An employee obtained a loan of P11,OOO at the rate of 7% compounded annually in order to build a house. How much must he pay monthly to amortize the loan within a period of 1 year? Construct an amortization schedule. * please do amortization schedule. Thankyou
Michael Sanchez purchased a condominium for $89,000. He made a 20% down payment and financed the balance with a 30 year, 5% fixed-rate mortgage. (Round your answers to the nearest cent. Use this table, if necessary.) (a): What is the amount (in $) of the monthly principal and interest portion, PI, of Michael's loan? $ (b): COnstruct an amortization schedule for the first four months of Michael's mortgage. (attached is the chart have to fill out for anwser) (C): If the annual property taxes are $1,640 and the hazard insurance premium is $730 per year, what is the total monthly PITI of Michael's loan (in $)? $
Kyle received a loan of $8,000 at 4.32% compounded semi-annually from a credit union to use as working capital for his business. He had to make semi-annual payments for a period of 4 years to settle the loan. a. Calculate the size of his payments. Round to the nearest cent b. What was the total interest paid during the period? Round to the nearest cent c. What was the interest portion of payment number 3?
Devin received a 15 year loan of $305,000 to purchase a house. The interest rate on the loan was 4.10% compounded semi-annually. a. What is the size of the monthly loan payment? Round to the nearest cent b. What is the balance of the loan at the end of year 4? Round to the nearest cent
Miss Clare Jarrett just closed a loan of $400 000 to assist with the purchase of equipment and fixtures for her small business. This loan will be repaid in five equal annual end-of-year instalments at an interest rate of 8% compounded annually. Complete the following: Determine the yearly payment Prepare an amortisation schedule What is the loan balance just after the end of year three? How much interest expense will Clare pay over the life of the loan? What would be the effective rate of interest if interest were to be compounded quarterly? Semi-annually?
Find the monthly payment for the loan indicated. yo purchase a home, a family borrowed $97,000 at an annual interest rate of 6.3% for 20 years. $____
Michael Sanchez purchased a condominium for $91,000. He made a 20% down payment and financed the balance with a 30 year, 5% fixed-rate mortgage. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount (in $) of the monthly principal and interest portion, PI, of Michael's loan? $ (b) Construct an amortization schedule for the first four months of Michael's mortgage. PaymentNumber MonthlyPayment(in $) MonthlyInterest(in $) Portion Usedto ReducePrincipal(in $) LoanBalance(in $) 0 $ 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $ (c) If the annual property taxes are $1,670 and the hazard insurance premium is $640 per year, what is the total monthly PITI of Michael's loan (in $)? $
An employee obtained a loan of P486,555 at the rate of 20.774% compounded bimonthly to build a house. Determine the following: 1.Nominal interest rate compound twice a month %. 2.Amount he has to pay at the end of thw 15 years? 3.Equal amount to be paid at the end of 5th and 7th year to be fully paid.
Michael Sanchez purchased a condominium for $73,000. He made a 20% down payment and financed the balance with a 30 year, 5% fixed-rate mortgage. (Round your answers to the nearest cent. Use this table, if necessary.) (a) What is the amount (in $) of the monthly principal and interest portion, PI, of Michael's loan? $ (b) Construct an amortization schedule for the first four months of Michael's mortgage. PaymentNumber MonthlyPayment(in $) MonthlyInterest(in $) Portion Usedto ReducePrincipal(in $) LoanBalance(in $) 0 $ 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $ (c) If the annual property taxes are $1,640 and the hazard insurance premium is $670 per year, what is the total monthly PITI of Michael's loan (in $)? $…
Jada and Izaak borrowed $40,000 at 5.53% compounded quarterly as a second mortgage loan against their current home. Repayment amount is $750 at the end of every month. a. How many payments are required to repay the loan? Number of payments 61 b. Use the given information to complete the amortization table below. Determine the missing values for the first two payment intervals, the last two payment intervals, and the totals. Report results to the nearest cent. Payment Amount Number Paid ($) 0 1 2 N - 1 N Total 750.00 750.00 : : 750.00 2,175.72 X 47,175.72 X Interest Paid ($) 183.49 192.61 10.58 6.96 : : : X 6,432.68 X X X Principal Repaid ($) 566.51 557.39 : 739.42 1,425.72 X 40,000 X X X Outstanding Balance ($) 40,000.00 39,433.49 38,876.10 : X 1,425.72 X 0.00
Jada and Izaak borrowed $40,000 at 5.53% compounded quarterly as a second mortgage loan against their current home. Repayment amount is $750 at the end of every month. a. How many payments are required to repay the loan? Number of payments b. Use the given information to complete the amortization table below. Determine the missing values for the first two payment intervals, the last two payment intervals, and the totals. Report results to the nearest cent. Payment Amount Number Paid ($) 0 1 2 : N - 1 N Total 750.00 750.00 : 750.00 Interest Paid ($) : : Principal Repaid ($) : : Outstanding Balance ($) 40,000.00 ⠀ : 0.00
Jason received a 30 year loan of $290,000 to purchase a house. The interest rate on the loan was 2.80% compounded semi-annually. a. What is the size of the monthly loan payment? Round to the nearest cent b. What is the balance of the loan at the end of year 3?