Revise your worksheet to reflect these updated assumptions and then answer the questions that follow.Loan amountAnnual interest rateNumber of yearsDecember 31, 2021December 31, 2022December 31, 2023December 31, 2024Required:1. Use your spreadsheet to recalculate the amortization table amounts and enter your revised results for the yearsindicated. Assume the bonds were issued on January 1.Note: Round your answers to 2 decimal places.No1Date2$ 465,00038%$4X Answer is not complete.Cash Paid140,393.17140,393.17140,393.17$ 140,393.17 $2. Prepare the journal entries to record the issuance of the note and the first two annual payments.Note: If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.Round your answers to 2 decimal places.DateJanuary 01, 2021 CashNotes PayableCarrying ValueDecember 31, 201 Notes PayableInterest ExpenseCash361,806.83250,358.21 X129.993.70 x> Answer is complete but not entirely correct.General JournalDecember 31, 201 Notes PayableInterest ExpenseCash0.00Debit465,000.00103,193.1737,200.00111,448.6228,944.55Credit465,000.00140,393.17140,393.17

Notes payable can be defined as a written agreements which specifies certain conditions as per which…

Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Loan amount Annual interest rate Number of years $ 465,000 8% 4 Required: 1. Use your spreadsheet to recalculate the amortization table amounts and enter your revised results for the years indicated. Assume the bonds were issued on January 1. Note: Round your answers to 2 decimal places.

Revise your worksheet to reflect these updated assumptions and then answer the questions that follow. Loan amount Annual interest rate Number of years $ 465,000 8% 4 Required: 1. Use your spreadsheet to recalculate the amortization table amounts and enter your revised results for the years indicated. Assume the bonds were issued on January 1. Note: Round your answers to 2 decimal places.

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

As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $260,000 9.50% 25 $ $6,573 $2,126 $
Using manual formulas and not excel:
Complete the following table: (Use Table 15.1.) (Do not round intermediate calculations. Round your answers to the nearest cent.) First Payment Broken Down Into— Selling price Down payment Amount mortgage Rate Years Monthly payment Interest Principal Balance at end of month $221,000 $44,200 7.00 % 15
Calculate the monthly payments for each of the following $119,600 mortgage loans. Assume no prepayments. a. 30-year fixed at 7.25 percent b. 15-year fixed at 6.25 percent c. 20-year fixed at 6.75 percent 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: a. The monthly payment, PMT, on the 30-year loan is $ (Round to the nearest cent.)
As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $280,000 3.50% 25 $ $6,573 $2,156 $
Hi, below is an attached photo of the question. Please show explanation of calculations. Thankyou.
A borrower has two alternatives for a loan: (1) issue a $570,000, 90-day, 7% note or (2) issue a $570,000, 90-day note that the creditor discounts at 7%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. (1) $570,000, 90-day, 7% interest-bearing note: $ (2) $570,000, 90-day note discounted at 7%: $ c. Alternative is more favorable to the borrower because the borrower
Compute the present value of a $2,000 deposit in year 1, and another $2,500 deposit at the end of year 4 using an 8 percent interest rate. (Do not round intermediate calculations and round your final answer to 2 decimal places.)
The loan below was paid in full before its due date. (a) Obtain the value of h from the annual percentage rate table. Then (b) use the actuarial method to find the amount of unearned interest, and (c) find the payoff amount. Regular Monthly Payment $445.22 Remaining Number of Scheduled Payments after Payoff 6 APR 11.0% Click the icon to view the annual percentage rate table. (a) h=$ (b) The unearned interest is $ (c) The payoff amount is $ (Round to the nearest cent as needed.) (Round to the nearest cent as needed.)
Using this table as needed, calculate the required information for the mortgage. Number Table Total Monthly Payment (in $) Term Amount Interest of Loan of $1,000s Factor Interest Financed Rate (years) Financed (in $) (in $) $85,500 8.00% 30 %24 %24 %24
As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI (in $), using this table and the monthly PITI (in $) for the mortgage. (Round dollars to the nearest cent.) AmountFinanced InterestRate Termof Loan(years) MonthlyPI AnnualPropertyTax AnnualInsurance MonthlyPITI $220,000 7.50% 25 $ $6,543 $2,156 $
1) Let y be the balance in an account if you deposit $5000 for x years at 4% APR compounded monthly. USE ALL DECIMALS except in e and fand h! a) Write the formula for y = f(x) b) Then rewrite the formula as an annual compounding (APY) formula as shown in the Lecture 16 notes. y = (rewritten). c) The APY (clear from part b) is: d) Then use the 2âd version of y to write y ' - e) How much is the investment worth after 7 years? f) How fast is the investment growing after 7 years? g) What is the percentage rate of growth (PROC) after 7 years as a percent? USE ALL DECIMALS! h) Write a sentence translating into English your answer for f' (7) : i) Show the second way to find the derivative of your formula in a) using the chain rule (as found in the chain rule lecture): j) Find y'(7) from your answer in j and confirm it is the same (at least to 7 decimals) as using the formula in d.