Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years (180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?

Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that you have the following two loans with monthly payments in the table attached as Choice 1 and Choice 2. Assuming that there is no origination cost with the loans. If Robin pays off the loan in 15 years (180 months), what is the incremental cost of the $10,000 for loan 1 over loan 2?

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.17: Amortized Loans

Problem 1ST

See similar textbooks

Similar questions

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)
Using the information provided please show all work and formulas in excel ! Suppose that you have two loan choices with monthly payments (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans?
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?
The formula below finds the monthly payment for a loan (car, mortgage, student): P=I (r/1-(1+r)-n ) 7. If you want to buy a car that costs $16,000 with a loan at 3% APR how many years should you finance the car if you want your payment to be below $230? Do this problem any way you want, but clearly communicate your thinking.
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%.
Pls help on ur own.Suppose you take out a car loan that requires you to pay $8,000 now, $5,000 at the end of year 1, and $7,000 at the end of year 2. The interest rate is 5% now and increases to 9% in the next year. What is the present value of the payments?
For the following economic calculations, write the factors (multipliers) that should be used,in (i) using the parameter values, and in (ii) calculate the result by showing your computations. Write the results you find in the spaces left. (Use factors for your calculations.)EXAMPLE: If you deposit $ 100 to a bank account that earns 8% annual interest, how much money will you have in this account after five years?(i)(F/P, 8%, 5) (ii)146.93100 * (F/P, 8%, 5) = 100 * 1.4693 = 146.93 TLa. You plan to take a credit with $1500 installment size per year with an annual interest rate of 8% over six years from a bank. What is the amount of your current credit?(i) (ii)b. A bank is required to deposit money for four years with an interest rate 10%. The money deposited at the end of the first year is 6000 TL and the amount of money deposited in the next three years will be reduced by 500 TL every year. How much money will be in the bank at the end of the fourth year?(i) (ii)
What is the monthly payment for a 5 year new car loan, when the nominal annual interest is 6%. After the down payment and other up-front charges, the amount borrowed is $21,000. Show your calculations and results using two methods: Use Engineering Economy factors and the compound interest tables found in Appendix C. Using spreadsheet. Set up table with known values and use Excel payment function (PMT
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
You lend a friend $10,000, which your friend will repay in 5 equal annual end-of-year payments of $3,000, with the first payment to be received 1 year from now. What rate of return does your loan receive? I need to be able to use excel and manually calculate as well.
Suppose you want to borrow $90,000 and you find a bank offering a 20-year loan with an APR of 5%. a. Find your regular payments if you pay n = 1, 12, 26, 52 times a year. b. Compute the total payout for each of the loans in part (a). c. Compare the total payouts computed in part (b). a. The payment for n = 1 would be $ The payment for n = 12 would be $ The payment for n = 26 would be $ The payment for n= 52 would be $ (Do not round until the final answer. Then round to the nearest cent as needed.)
You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money would you have in your savings account in 36 months for your trip? ( Please reference the loan infromation in the "Task 5 Data " cells as the argument for your functions