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 this website: https://www.bankrate.com/mortgages/amortization-calculator/ The loan start date will be January 2023.

Imagine a loan of $420,000. The loan is to be repaid in six years (i.e., last payment at the end of month 72). If the APR of this loan is 7.80%, what will be your monthly payments? $7,724 $7,643 $7,451 $7,323 $7,548

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

Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) AmountFinanced Number ofPayments APR TableFactor FinanceCharge MonthlyPayment $700 18 17% $

Consider a student loan of ​$12,500 at a fixed APR of 12​%for 25 years. What is the monthly payment?​(Do not round until the final answer. Then round to the nearest cent as​ needed.) The total payment over the term of the loan is?​(Round to the nearest cent as​ needed.)  Of the total payment over the term of the​ loan ​%? is paid toward the principal and ​%? is paid toward interest.

For each case, provide the missing information. Assume payments occur at the end of each period. (Use the present value and future value tables, the formula method, financial calculator, or a spreadsheet for your calculations. If using present and future value tables or the formula method, use factor amounts rounded to five decimal places X.XXXXX. Round all final answers to the nearest cent, $X.XX, and round the loan maturity date to the nearest whole year.) (Click the icon to view the cases.) Future Value of $1 table Future Value of an Ordinary Annuity table Future Value of an Annuity Due table Cases Amount borrowed Interest rate Number of periodic payments per year Maturity (in years) Periodic payment (1) (a) 4% 4 10 $ 10,354.90 (2) $ 675,000 $ 4% 2 10 (b) S CO (3) 456,000 6 % 1 (c) 81.685.59 (4) $ 750.000 12 % T (d) I X

show steps to calculation With screenshots of excel!!! As a borrower, you have the option to choose between two 30-year, monthly-payment loans: 7% interest rate with 3 points, versus 7.5% interest with one-half point. (a) Which loan option would you choose if you had a 10-year expected prepayment horizon? (b) Which would you choose if you expect to pay off this loan in 5 years?

Show the first two lines of the amortization table for your new home mortgage, assuming a sellingprice of $118,500, a down payment of 6%, annual interest rate 5.3% compounded monthly, andmonthly payments on a 30-year mortgage. (Please help by solving through calculator)

You are comparing two investments. The first pays 3 percent interest per month, compounded monthly, and the second pays 6 percent interest per six months, compounded every six months. a. What is the effective semiannual interest rate for each investment? b. What is the effective annual interest rate for each investment? c. Based on the interest rates, which investment is preferred? Does the decision depend on whether the comparison is based on an effective six-month rate or an effective one-year rate? a. The effective semiannual interest rate for the first investment is percent. (Type an integer or decimal rounded to two decimal places as needed.)