HomeInsertDrawPage LayoutFormulasDataReviewViewTell meArial10A A°Wrap Text vGeneralA$ v % 9PasteВUMerge & Center v13fxAВCEFJ12 Name: KhanGhulam IIII II ||3 Amortization Schedule4 Instruction: Develop and amortization table for the payment of a loan on a house.Payments are monthly for 10 years.Loan on the house is $179,000.56.PMT formula7Interest is 5.3% annual.8PV formula9Payment:1011Payment PaymentNumberMonth|РaymentAmountBeginningEndingTowardToward12BalanceBalancePrincipalInterestApr-02May-02131179,000.00141531641718197208219.22102311241225132614271528162917301831193220lili

A loan refers to the number of borrowings that the individual or the organization takes from any…

Answered: 2 Name: KhanGhulam III II || 3…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Question 11 Larry invested $12,000 at an interest rate of 10.18% for 4 years. If the amortization schedule needs to be constructed, what is the Payment to Principal for the fourth period? A $3,117.32 B) s2,813.29 $2,296.58 $3,449.27
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $35,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $35,000 %24 24 24 $0.00 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 2. 3. 4-
39 Identify the correct formula to calculate the payment for a loan, where the rate is 6%, the loan amount is $2,000, and payments will be made monthly for six years. =PMT(6,6*12,2000) =PMT(.06/12,6*12,-2000) once=1/1b1435-b60f-40fb-ad57-d89084c2075a&launchCode=qe8mtdEeV5pWjPP2nq... =PMT(.06,6*12,-2000) =PMT(.06,6*12,2000)
Payment Calculator Property Location Fullerton Payments per year 12 Property Cost $750,000 Total Payments 360 Down Payment $75,000 Interest (APR) 4.00% Loan Amount $675,000 Payment (per month) Period (Years) 30 Pleasae use the formula PMT to determine the payment per month.
Question Help 5.5.15 A $244,500 mortgage for 15 years for a new home is obtained at the rate of 8.9% compounded monthly. Find (a) the monthly payment, (b) the interest in the first payment, (c) the principal repaid in the first payment, and (d) the finance charge. (a) The monthly payment on the mortgage is $ (Round the final answer to two decimal places as needed. Round all intermediate values to six decimal places as needed.)
Amortization Table A loan of $11,000 is to be repaid over a 2-year period through equal quarterly installments with an interest rate of 13% per year compounded quarterly. Determine the size of each installment. Part 1 of 2 Use a TVM solver to solve this problem. Fill in the information that you typed into the TVM solver. Round the final answer to two decimal places. N = 1% = PV = 8 ✔ 13 11000 PMT= alpha ✔ 8 13 Final Answer: $1583.59 11000 alpha FV = P/Y = C/Y = 1583.59 o PMT: (End/Begin) End✔ ✔ Part 2 of 2 Verify the installment amount by filling in the amortization table. X 1583.59 1583.59 ✓ 1583.59 1583.59 ✔ 1583.59 ✔ 1583.59 ✔ 1583.59 1583.59 0 End of Period Interest Charged Repayment Made Payment Toward Principal Outstanding Principal 0 11000 ✓ 1 x 2 X 3 X 4 X 5 6 7 8 ✓ 4 End X X X
Question Completion Status: O $255,243,325.72 QUESTION 2 Ann found an apartment that costs $800,000 to buy. She will make a $100,000 down payment and get a mortgage for $700,000. The mortgage will be a fully amortizing 30-year fixed rate mortgage at 4.25% with monthly payments and monthly compounding. The following 6 questions will use this information above (round all answers 2 decimal places. do not inclue commas or dollar signs in responses. enter percentages as whole numbers i.e. 4.952% should be entered as 4.95) a) What is Ann's Loan to Value when she gets the Loan? 87.5 b) What will Ann's monthly mortgage payment be? c) What will be the balance on Ann's mortgage after the 7th monthly payment d) How many dollars is Ann paying in interest in her 8th monthly mortgage payment? e) How many dollars of Ann's 8th monthly mortgage payment will be principal? f) What is the total sum of all cash flows that Ann will pay the bank over the entire life of the loan, assuming she keeps the loan…
Narrative 14-1For problems in this section, use Table 14-1 from your text to find the monthly mortgage payments, whennecessary. Refer to Narrative 14-1. You purchase a home for $69,750 at 6.75% for 30 years. The property taxes are $2,450per year, and the hazard insurance premium is $256 semiannually. Find the monthly PITI payment. Group of answer choices 699.51 $594.73 $1,059.40 $246.83
Question 12 A Php370,000 loan is to be amortized at 10% compounded semi-annually for 3 years. The semi-annual payment is Php67,173.49. From the given table below, what is the interest incurred in the second period? Period 0 1 2 3 4 5 6 Periodic Payment None Php67,173.49 Php67,173.49 Php67,173.49 Php67,173.49 Php67,173.49 Php67,173.49 Php9,250 Php59,371.58 Php252,704.93 Php 7,801.91 Interest Payment None Principal Repayment None Outstanding Balance Php370,000 12
TABLE 14.2 Loan amortization table (monthly payment per $1,000 to pay principal and interest on installment loan) Terms in months 6 12 18 24 30 36 42 48 54 60 7.50% $ 170.34 86.76 58.92 45.00 36.66 31.11 27.15 24.18 21.88 20.04 8.00% $ 170.58 86.99 59.15 45.23 36.89 31.34 27.38 24.42 22.12 20.28 8.50% $ 170.83 87.22 59.37 45.46 37.12 31.57 27.62 24.65 22.36 20.52 9.00% $ 171.20 87.46 59.60 45.69 37.35 31.80 27.85 24.77 22.59 20.76 10.00% $ 171.56 87.92 60.06 46.14 37.81 32.27 28.32 25.36 23.07 21.25 10.50% $ 171.81 88.15 60.29 46.38 38.04 32.50 28.55 25.60 23.32 21.49 11.00% $ 172.05 88.38 60.52 46.61 38.28 32.74 28.79 25.85 23.56 21.74 11.50% $ 172.30 88.62 60.75 46.84 38.51 32.98 29.03 26.09 23.81 21.99 12.00% $ 172.55 88.85 60.98 47.07 38.75 33.21 29.28 26.33 24.06 22.24 12.50% $ 172.80 89.08 61.21 47.31 38.98 33.45 29.52 26.58 24.31 22.50 13.00% $ 173.04 89.32 61.45 47.54 39.22 33.69 29.76 26.83 24.56 22.75 13.50% $ 173.29 89.55 61.68 47.78 39.46 33.94 30.01 27.08 24.81 23.01…
Question content area top Part 1 Calculate the monthly payments of a 3030-year fixed-rate mortgage at 6.006.00 percent for $136 comma 200136,200. How much interest is paid over the life of the loan? Note: Round intermediate computations to at least five (5) decimal places. Click on the table icon to view the Monthly Installment Loan Payment Factor (MILPF) table: LOADING... . Question content area bottom Part 1 The monthly payments of a 3030-year fixed-rate mortgage at 6.006.00% for $136 comma 200136,200 is $817.2817.2. (Round to the nearest cent.) Part 2 The amount of interest paid over the life of the loan is $enter your response here. (Round to the nearest cent.)
AmortizationThe accountant requests a loan of $2,000 from a bank; agrees to make quarterly payments, for two years, at a rate of 24% compounded monthly. Make an amortization table.

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS