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)

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)

International Financial Management

14th Edition

ISBN:9780357130698

Author:Madura

Publisher:Madura

Chapter4: Exchange Rate Determination

Section: Chapter Questions

Problem 6BIC

See similar textbooks

Similar questions

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)
You are planning to buy a CD for $1,352. You will receive $1,500 in 2 years. Use a financial calculator to find the interest rate you will receive on that investment, assuming annual compounding. I can do this manually, but can't seem to figure out how to correctly input this into a financial calculator using N, I/Y, PV, PMT, and FV.
Suppose that you need an amount of money which equals to $10000000. It is possible to find it from bank A at an annual interest rate of 18% under 12 equal payment. If the first payment will be 1 month later the day you used the loan. Find the CF (Cash Flow), the equal payments and prepare the amortization table.
Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of $35,000 which is to be paid off in full after 3 years. Interest is charged at a rate of 4.43% per year and the payment to the loan is to be made at the end of each month. Which function argument is correct? (Reminder: =PMT(rate, nper, pv, [FV], [type]) =PMT( 4.43%, 36, -35000) =PMT( 4.43%/12, 36, -35000) =PMT( 4.43%/12, 3, -35000) =PMT( 4.43%, 3, -35000)
It is important to know how to build an amortization schedule when firms (or individuals) take out bank loans. It all start with calculating the monthly payment using the formula below.using the formula provided, do calculations to confirm the monthly payment for that loan based on the following information Loan amount (P): $60,000 Number of periods (n): 3 years = 36 months Interest (i): 12% per year = 1% per month (should be expressed as 0.01)
The time value of money is used for many important financial decisions that could affect long-term goals. The interest rate you pay on a loan can affect the amount you pay each period. An advertised monthly lending rate of 9% is about 11% per year. This difference between an advertised rate and the annualized rate is based on finer TVM details that may be overlooked by borrowers. What practical TVM application would you expect to encounter in your future? Explain.
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, use the PMT function to determine what your monthly payment will be. Submit the spreadsheet in Canvas.
You are taking out a single-payment loan that uses the simple interest method to compute the finance charge. You need to figure out what your payment will be when the loan comes due. The equation to calculate the finance charge is: FsFs = Amount of Loanx Interest Ratex Term of Loan where FsFs is the finance charge for the loan, and the term of the loan is in . You’re borrowing $10,000 for two years with a stated annual interest rate of 6%.
A loan of $5,000 with interest at 7.75% compounded annually is amortized by equal payments at the end of each year for five years. 1. Show your financial calculator inputs for the payment calculation. 2. Create a full amortization schedule for the loan. A template is available in the Test folder (underneath the link to our test. You can fill in the Word file template and attach below,
Suppose you are buying your first condo for $190,000, and you will make a $10,000 down payment. You have arranged to finance the remainder with a 30-year, monthly payment, amortized mortgage at 3.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? You are not required to show calculations. However to receive credit you must provide the inputs used (N, PMT, FV, I/Y, PV) to solve. If you utilize a template, you can copy and paste the section used in the submission. $808.28 $853.18 $527.78
You have been assigned to estimate the interest rates that your company may have to pay when borrowing money in the near future. The following information is available.kPR = 2%MR = 0.1% for a 1 year loan increasing by 0.1% for each additional yearLR = 0.05% for a 1 year loan increasing by 0.05% for each additional yearDR = 0 for a 1 year loan, 0.2% for a 2-year loan, increasing 0.1% for each additional yearExpected Inflation Rates Year 1 = 7% Year 2 = 5% Year 3 and thereafter = 3% a. Calculate the inflation adjustment (INFL) for a 5-year loan. b. Calculate the appropriate interest rate for a 5-year loan.
An advertised monthly lending rate of 9% is about 11% per year. This difference between an advertised rate and the annualized rate is based on finer TVM details that may be overlooked by borrowers. Discuss how you may have used TVM in a recent investment or loan decision and explain the TVM involved in your transaction. If you have not used TVM in the past financial transactions what practical TVM application would you expect to encounter in your future.