Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period 27 Rate is APR Payment 2229.45 Loan amount 358000

Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45 Let's use references for input values; and be sure to annualize the rate! INPUTS: OUTPUT: Period 27 Rate is APR Payment 2229.45 Loan amount 358000

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 7FPE: Calculating interest and APR of installment loan. Assuming that interest is the only finance charge,...

See similar textbooks

Related questions

Q: his morning you purchased a stock that just paid an annual dividend of $2.40 per share. You require…

A: When the company receives profits and distributes them among the shareholders. That share of profit…

Q: The common stock of the C.A.L.L. Corporation has been trading in a narrow range around $105 per…

A: As per the given information:

Q: Suppose that the risk-free interest rate is 12% per annum with continuous compounding and a stock…

A: First, let's calculate the present value of the expected dividends:PV(dividends) = 1/(1+0.123/12) +…

Q: At what nominal rate of interest compounded quarterly will $ 6900 earn $1500 interest in eight…

A: Both PV and FV are essential concepts for investors as they provide valuable insights into the…

Q: Scheduled loan payments of $1105 due in 9 months and $1216 due in 24 months are rescheduled as a…

A: The time value of money is a fundamental concept in finance that recognizes the idea that the value…

Q: At toy store, customers can choose a stufled animal and add accessories like a hat or sunglasses.…

A: It is a problem that involves the calculation of the price for a stuffed animal and related…

Q: Happy Time Inc. is expected to generate the following cash flows for the next year, as shown in the…

A: The expected return is the estimation of profit or loss that an investor determine from his…

Q: The share price of a company is shs100. Its expected next dividend is shs3. The dividend and share…

A: Gorden Growth model is used to determine the intrinsic value of share or stock using the dividend,…

Q: Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds…

A: Cost of debt refers to the overall weighted cost of debt of all the bonds to the company.

Q: A store offers its salespeople a table with coefficients to be applied to the cash sale value of its…

A: Present value is the current value of a future stream of cash flows, considering the time value of…

Q: Suppose that we can describe the world using two states and that two assets are available, asset K…

A: The risk-neutral probability refers to the probability of a state occurring after it has been…

Q: Concord Corporation has the following accounts at December 31: Common Stock, $11 par, 5,700 shares…

A: Stockholders equity is one of important section of balance sheet of the business. It shows total…

Q: Which of the following is the purpose of an Auditor’s Report? 1. To inform readers that financial…

A: The purpose of an Auditor's Report is to provide an independent opinion on the financial statements…

Q: WHAT IS THE FINANCIAL SYSTEMS' APPROACH TO MICROFINANCE?

A: The financial systems' approach to microfinance focuses on viewing microfinance as an integral part…

Q: Suppose you conduct currency carry trade by borrowing $1,000,000 at the start of each year and…

A: As per the given information:Borrowing = $1,000,000Exchange rate on January 1, 2000 = NZ$1.9110/$

Q: The following table presents information on a potential project currently being evaluated by XYZ.…

A: Payback period is the number of years in which the initial cost of the project is recovered.Net…

Q: e common stock of the P.U.T.T. Corporation has been trading in a narrow price range for the past…

A: According to put call parity the price of call option and put option must be in equilibrium with…

Q: ABC corporation has $600 mil worth bonds outstanding at face value with a 8.5% coupon rate paid…

A: When the company receives profits and distributes them among the shareholders. That share of profit…

Q: Give typing answer with explanation and conclusion Four years after the issue of a $10,000, 8.9%…

A: Face value = $10,000Coupon rate = 8.9% (Semi-annual payments)Bond period = 20 yearsYield on bond =…

Q: The Neal Company wants to estimate next year's return on equity (ROE) under different financial…

A: Return on equity refers to the return to be earned by the equity shareholders in a definite period…

Q: miba PLC is looking for financial investments in the securities market. Two investment options are…

A: Value of bond is the sum of present value of coupon payments and present value of par value of bond…

Q: my Shoes Inc. has 10,000 shares outstanding with a stock price of $40 per share. The current…

A: EPS (Earnings per share) is calculated as shown below.

Q: Derry Corporation is expected to have an EBIT of $2,950,000 next year. Depreciation, the increase in…

A: Next year EBIT=$2,950,000Increase in depreciation =$230,000Increase in net working…

Q: Which one of the following will decrease the net present value of a project? Group of answer…

A: The NPV of the project refers to the net value of its cash flows after they have been discounted to…

Q: M.a.k.e. .a. .s.i.m.p.l.e. .e.x.p.l.a.n.a.t.i.o.n. .w.i.t.h. .e.x.a.m.p.l.e. .o.f. .t.h.e.…

A: Capital Structure: Bond ValuationExplanation: Capital structure refers to the way a company finances…

Q: ΔΝΡΜΙΔΡ ΔΗΡV/ΔΩ

A: In the given question we need to calculate the sensitivity of the NPV to changes in the price and…

Q: FINANCIAL MANAGEMENT; 1) Your firm has just issued a 15-year $1,000.00 par value, 10% annual coupon…

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

Q: Consider the characteristics of the following three stocks: Expected Return 12% 10 15 Pic Image Tax…

A: Pic Image and Warm WearPic Image and Tax Help have similar expected returns and standard deviations.…

Q: What is the present value of a 8-year ordinary annuity with annual payments of $511, evaluated at a…

A: Annuity is the fixed sum of money or fixed amount of cash flow occurring for certain number of years…

Q: Jordan, Corp., has debt outstanding with a market value of $3 million. The value of the firm would…

A: Given data:> Market value of the debt = $3 Million> Market value of the equity = 3,60,000 *…

Q: typing answer with explanation and conclusion Manufacturing company spent $28,000 on a new conveyor…

A: Amount of savings must be sufficient to satisfy the amount of initial investment and that must be…

Q: Suppose the value of the S&P 500 stock index is currently 2,400. a. If the 1-year T-bill rate is 6%…

A: Futures price is the spot price plus the risk-free return on it. If the underlying asset has…

Q: The Redwood Company is financed entirely with equity. The company is considering a loan of $20…

A: Amount of Loan is 20 millionCost of Loan is 8%Time Period of Loan is 2 yearsTax Rate is 24%

Q: Suppose you sold short 100 shares of some stock on January 1 at a price of $30 per share. A dividend…

A: Gain on Sale = Sale Price of Shares - Cost of acquisition of Share - Transaction cost

Q: From the following information calculate the net present value of the two projects and suggest which…

A: First, we need to determine the net cash flow using the formula below:Net cash flow = cash flow +…

Q: A large profitable corporation bought a small jet plane for use by the firm's executives in January.…

A: The MACRS depreciation percentages for the 5-year property class are as follows:Year 1: 20.00%Year…

Q: Draiman Corporation has bonds on the market with 13 years to maturity, a YTM of 9.9 percent, a par…

A: Here,Price of Bond is $950Par Value of Bond is $1,000YTM is 9.90%Time to Maturity is 13 years

Q: a) What do the financial Markets suggest for inflation in the US next year b) Estimate Today's one…

A: Interest rates are very important in determining exchange rate and both changes according to that…

Q: A firm has sales of $41,000, costs of $19,500, addition to retained earnings $5,100, dividends paid…

A: Here,Sales is $41,000Cost is $19,500Addition to Retained Earning is $5,100Dividend paid is…

Q: NBM common stock recently paid annual dividend in the amount of $2.25 per share. The analyst’s…

A: Stock price refers to the price at which shares are bought and sold in the market by the investors…

Q: Jennifer is the owner of a video game and entertainment software retail store. She is currently…

A: CompoundingCompounding is the method through which interest is added to the existing principal…

Q: Alpha Moose Transporters has a current stock price of $22.35 per share, and is expected to pay a…

A: Here,Growth rate is 5.20%Price of Share is $22.35Floatation Cost id 6.50%Expected Dividend is $1.36

Q: Discuss the ethics requirements for tax practitioners. Please discuss both the AICPA Statements of…

A: The ethics requirements for tax practitioners are outlined in both the AICPA Statements of Standards…

Q: any is considering lenghtening its credit period from 40 days to 45 days and believes, as a result…

A: Company gives credit to customers to increase sales but there are cost of credit policy also so if…

Q: Charisma is able to pay $1250 a month for a 25-year mortgage with end of month payments. Because of…

A: It is a case of loan amortization where the monthly payment is given with a 20% down payment done…

Q: Use the MIRR decision rule to evaluate this project. (Do not round intermediate calculations and…

A: MIRR stands for Modified Internal Rate of Return. It determines the return of the project taking…

Q: Acme Oscillators is considering an investment project that has the following rather unusual cash…

A: Here,YearCF0 $ 10,00,00,000.001 $ -46,04,00,000.002 $ 79,05,00,000.003 $ -60,16,00,000.004 $…

Q: Find out how sensitive the investment decision of this investment alternative is to its revenues.…

A: First we are going to determine the PV of cash flows by inputting the following values in a…

Q: Q#2: Debt to Assets Ratio Debt to Equity…

A: "Since there are multiple questions posted, answering only the first question as per the guidelines.…

Q: y led Tea currently rents a botting machine for $54,000 per year, including all maintenance…

A: Npv is the discounted present value of all the future cash flows after deduction of initial…

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

I need the excel function typed out? Example =RATE????

G. Find the interest rate (APR) on a 27-year mortgage with a initial loan amount of $358,000, if the monthly payment is $2229.45
Let's use references for input values; and be sure to annualize the rate!

INPUTS:		OUTPUT:
Period	27	Rate is	APR
Payment	2229.45
Loan amount	358000

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: Introduction

VIEW

Step 2: Calculations

VIEW

Solution

VIEW

Step by step

Solved in 3 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

Calculating interest and APR of installment loan. Assuming that interest is the only finance charge, how much interest would be paid on a 5,000 installment loan to be repaid in 36 monthly installments of 166.10? What is the APR on this loan?
Consider a traditional 30-year fixed rate mortgage, borrowing $400,000 (present value) at an annual interest rate of 3.25%, payable in monthly payments. Create an Excel spreadsheet and use basic math functions to develop a schedule for the entire life of the loan. Your table should include columns for Payment #, Principle Remaining, Interest Paid, Principal Paid, Cumulative Interest Paid, and Cumulative Principal Paid. Then use this table to answer the following questions: c. How much did the borrower pay in total to pay off this loan, if they paid just the minimum payment for the entire 30 years? And how much of that total is just interest? d. Create a graph of the interest and principal amounts paid each month, for just the first two years of the loan. (Hint: use an “X Y Scatter” chart type) e. Bonus question: How much sooner (in months) would the borrower pay off this loan, if they paid an extra $100 per month? Your Excel spreadsheet must show this calculation
Please show how to solve using an excel spreadsheet: Suppose you borrow $250,000 PLAM (Price Level Adjusted Mortgage) for 30 years, monthly payments with $6,000 origination cost. The mortgage rate is 6% with annual outstanding balance adjustments based on the following inflation information in the table attached.
Use Excel to solve this problem.An $11,000 mortgage has a 30-year term and a 6% nominal interest rate.(a) What is the monthly payment?(b) After the first year of payments, what is the outstanding balance?(c) How much interest is paid in Month 13? How much principal?
Need Detailed answer with steps please 30. Considering the following information, what is the NPV if the borrower refinances the loan? Expected holding period: 3 years, Current loan balance: $100,000; Current loan interest: 7%; Current loan mortgage payment: $898.33; Remaining term on current mortgage: 15 years; New loan interest: 5.5%; New loan mortgage payment: $817.08; New loan term: 15 years; Cost of refinancing: $5,000. Assume that the opportunity cost is the interest rate on the new loan (5.5%). A. -$5,000.00 B. -$1,155.27 C. $3,844.73 D. $8,844.73
A loan officer is preparing the documents for a commercial term loan. The borrower's risk profile suggests that an annualized return ( EAR) of 6.3% is appropriate. The loan will require semi - annual payments, i .e., one payment every six months. What APR (compounded semi - annually) should be used to compute the borrower's future payments? ( please show the results in excel spreadsheet also)
Use Excel to create an annual summary (5-years) amortization schedule for a fully-amortizing, fixed rate mortgage for $4,000,000 at 5.5% for 30 years, monthly payments, 1 discount point. Use the power of Excel. Show me the excel table. (Picture/Screenshot/Table)
you are analyzing a GPM. the terms are $60,000 loan amount, 9% note rate, 30 years, monthly payments, OFV, payments in year one based based upon 7%, and payment in year two based on 8%. how much will you owe on this loan at the end of the second year? Please assist, using HP 10bII+.
Please show all steps and formulas in an excel spreadsheet to answer a. through g. using the information below! You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
Use the PMT function in Excel to compute the monthly payment on a $351000 business loan at an annual interest rate of 4.46% over 30 years, where the interest is compounded monthly. Hint: The PMT (Payment) function is entered in Excel as =PMT(Rate, Nper, Pv, Fv, Type). Fv and Type are not necessary. Ignore them. Enter the amount of your monthly payment below. Do not include the dollar sign ($).
Data Back-Up Systems has obtained a $10,000, 90-day bank loan at an annual interest rate of 15%, payable at maturity. Show Solutions and Explanation. (Note: Assume a 365-day year.) A. How much interest (in dollars) will the firm pay on the 90-day loan? (Format: 111.11) B. Find the 90-day rate on the loan. (Format: 1.11%) C. Annualize your result in Part B to find the effective annual rate for this loan, assuming that it is rolled over every 90 days throughout the year under the same terms and circumstances. (Format: 11.11%)
Percentages need to be entered in decimal format, for instance 3% would be entered as .03 in cell B12.) Set up an amortization schedule for a $60,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 20%. What is the annual payment? After you input the data for each scenario, click on the Graph tab (second tab on the worksheet) and look at the Principal and Interest portions of the payments throughout the years. What do you notice about the amount of Principal and Interest over the years (which amount is higher in the early years, and which amount is higher in the later years) of the loan? What do you notice about the difference in Principal and Interest in the 10% scenarios compared to 20% scenarios?