Team, please create an amortization schedule which shows different dollar amounts you borrow at different interest rates. Assumptions are as follows: Assume a 25, 30, 35 and 40 year loan Interest rates from 2.5% to 4.5% in 1/4 increments (2.5% 2.75%, etc) Borrowing starting at 100,000 to 300,000 in 10,000 dollar increments (100,000, 110,000, etc) Note: Create and excel table for this exercise. Also refer to chapter 1 for the formula's if needed

Please include the excel formula If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months. Determine if the following situation is an investment or a loan.   If the following is an investment, identify a) if it is a one-time or recurring investment, b) the number of compounding periods per year and c) the total number of compounding periods. If the following is a loan, identify a) the principal amount, b) the monthly interest rate, and c) the length of the loan in months.   Ashtyn purchased new appliances for her house for a total of $5,744. The store she buys the appliances from offers an annual simple interest rate of 8.5% with no down payment and monthly payments for 3 years.   This situation represents a(n) . a)  b)  c)  What will be your monthly payments?  Use Excel to calculate the value.

A fully amortizing mortgage loan is made for $84,000 at 6 percent interest for 25 years. Payments are to be made monthly. Required: a. Calculate monthly payments. b. Calculate interest and principal payments during month 1. c. Calculate total principal and total interest paid over 25 years. d. Calculate the outstanding loan balance if the loan is repaid at the end of year 10. e. Calculate total monthly interest and principal payments through year 10. f. What would the breakdown of interest and principal be during month 50?

You borrow $2,400 to pay for a Caribbean vacation and will pay it off over 2 years with regular monthly What is the regular payment if interest is charged on the loan amount at APR of 8% interest is charged monthly on the balance still Create an amortization table for this loan on Excel What is the total amount of payments made in part a.? What is the total interest

Please make sure the answers are clear n easy to read. Please do it on white paper. Again make sure the answer is clear.  do it on white paper

A floating rate mortgage loan is made for $180,000 for a 30-year period at an initial rate of 12 percent interest. However, the borrower and lender have negotiated a monthly payment of $1,440. Required: a. What will be the loan balance at the end of year 1? b. If the interest rate increases to 13 percent at the end of year 2, how much is the payment plus negative amortization in year 2 and year 5 if the payment remains at $1,440? Complete this question by entering your answers in the tabs below. Required A Required B If the interest rate increases to 13 percent at the end of year 2, how much is the payment plus negative amortization in year 2 and year 5 if the payment remains at $1,440? Note: Do not round intermediate calculations. Round your final answers to 2 decimal places. Loan balance in year 2 Interest accrued - Year 2 Interest accrued - Years 2 - Year 5

I need help with this problem

A borrower has two alternatives for a loan: (1) issue a $300,000, 120-day, 8% note or (2) issue a $300,000, 120-day note that the creditor discounts at 8%. Assume a 360-day year. a.  Calculate the amount of the interest expense for each option.$ for each alternative. b.  Determine the proceeds received by the borrower in each situation. (1) $300,000, 120-day, 8% interest-bearing note $ (2) $300,000, 120-day note discounted at 8% $ c.  Alternative   is more favorable to the borrower because the borrower   .

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

Consider a 30-year, 8.5% loan for $130,000 with fixed monthly payments. Construct an amortization schedule for the following payment numbers: 1, 24, 60, 120, 180, 240 and 360.