Need hood explanation, don’t use excel please. Tsinoor takes out a loan of $6800. He will repay the loan over 5-years with semi-annual payments of $816 (first payment due in 6-months). Using linear interpolation, what rate of interest, j2 is being charged on the loan?
Q: A student takes out a student loan in her first year of college. The loan earns simple interest each…
A: Given: Interest rate = 8.75%
Q: Dr Musonda is struggling to repay his loan of K600,000 with payments of K12,800 made monthly in…
A: The future value is useful to investors and financial planners, as they use it to estimate how much…
Q: The Brown family recently bought a house. The house has a 30 year, $165,000 mortgage with a nominal…
A: Amount of mortgages is $165,000 Time period is 30 years Interest rate is 8% Total number of months…
Q: Sam would like to use the PMT function in Excel to calculate the monthly payments on a car loan of…
A: There are two types of annuities, i.e., (i) annuity due and (ii) ordinary annuity. An annuity can be…
Q: our business requests a 3-month loan for $500,000. What will be the interest paid at the end of the…
A: LIBOR stands for London Interbank Offered Rate. It is the benchmark rate at which all major global…
Q: You have taken a personal loan from Bank Muscat for 15,000 OMR and charged with an interest rate of…
A: Loan Amortization Table is as under -
Q: Ray Flagg took out a 60 mnth fixed loan installment of $12000 to open a new pet store. He pd no…
A: Finance charge on the bond is the total interest paid on the loan divided by the loan amount…
Q: On their website, they describe the terms of a $2600 installment loan at an effective APR of 139.13%…
A: Loan is the type of debt instrument which is usually for long-term with the pre-defined interest…
Q: A 5-years, $6000 loan is being amortized with monthly payments at j12 = 10%. Just after making the…
A: A loan is an annuity that contains a stream of a fixed amount of cash flows. The outstanding value…
Q: Deshaun took out a loan for $6100 that charges an annual interest rate of 9.7%, compounded daily.…
A: Part (a): Calculation of amount owned after one year: Answer: Amount owned after one year is…
Q: Solve the following problems by showing your formula and computation: 1. what is the simple…
A: “Hey, since there are multiple questions posted, we will answer first question. If you want any…
Q: Friendly’s Quick Loans, Inc., offers you $5.25 today but you must repay $6.55 when you get your…
A: The given question can be solved using RATE function in excel. RATE function computes interest rate…
Q: site, find another.) Type in a nome price of $300,000. Leaving all other entries as they are, enter…
A: “Hi There, thanks for posting the question. But as per Q&A guidelines, we must answer the first…
Q: John bought an expensive $2,740 stereo. He took out an amortized loan for the full amount at 3.12%…
A: A type of loan in which the borrower has to make a schedule for the periodic payment regarding both…
Q: The PC shop obtains a loan from a finance company. It is to be repaid by quarterly payments of PHP…
A: Quarterly payment (P) = PHP 50,000 First payment period = 2 Years First payment period in quarters…
Q: Your monthly payments are due on the 8th of each month, starting October 8. The lender receives your…
A: Principal amount : It is the initial or the total amount that is being borrowed by an individual…
Q: Joseph used the Quantitative Reasoning Procees to create a plan to pay off his student loans of…
A: Given information: Student loan = $7,680 Monthly Payment = 73.80 Time = 10 Annual interest = 2.9%
Q: e effective rate of interest of the loan?
A: Effective interest rate is calculated as follows; r = (1 + in)n -1 wherer - effective annual ratei -…
Q: 1. Glen received a $2,250 loan from the bank. After six months, he paid back an additional of $145…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: 1.Jude borrowed money from the bank.He received Php 18,000 & promised to pay Php 22,750 at the end…
A: Simple Interest: It is computed by multiplying the simple interest rate by the principal and the…
Q: Given a $5,000 loan at 8% for 90 days, compare the interest accrued using the standard method (365…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: A friend purchased a new sound system that was selling for $4200: He agreed to make a down payment…
A: Here, Purchase value of sound system = $4,200 Down Payment = $1,000 Monthly Payment = $160 No. of…
Q: Dave took out a $6200 loan at 14% and eventually repaid $10,540 (principal and interest). What was…
A: Future value of amount includes the original amount and amount of interest being accumulated over…
Q: Find the number of payments
A: Borrowings: Borrowings are the amount taken as credit from any financial organization. Borrowings…
Q: A car loan of $19,055.04 is to be repaid with end-of-month payments of $369.28. If interest is…
A: When money is given to another party in return for repayment of the loan principal plus interest, it…
Q: borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's…
A: The given problem can be solved using PMT function in excel. PMT function computes installment…
Q: A lending company charged its client P2,750 on a loan of P15,800 for 2 years and 3 months. What…
A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…
Q: Given the following information on a MPT, what is the servicing fee in year 3? (Round your answer to…
A: Mortgage pass through security is a pool of mortgages built and then sold as participation…
Q: A lending company charged its client P2,750 on a loan of P15,800 for 2 years and 3 months. What…
A: The rate of interest charged can be calculated with the help of simple interest function
Q: Ctenanthe Plant Co. borrows money to buy some new green houses. To do so, Ctenanthe borrows $750,000…
A: When amount is borrowed, we should pass an entry for cash and create a liability for the amount…
Q: The owner of a hotel borrowed $36,000 at 7.8% p.a. compounded semi-annually and agreed to repay the…
A: The question is based on the concept of Loan and amortization
Q: Dr Musonda is struggling to repay his loan of K600,000 with payments of K12,800 made monthly in…
A: Hi There, Thanks for posting the questions. As per our Q&A guidelines, must be answered only one…
Q: With the given information please confirm if my calculations for how many years it will take to pay…
A: using excel nper function
Q: Manjean is making car payments of $662 per month for the next 3 years. Manjean knows that the car…
A: Formula Car price = P*[1-(1+I)-N]/I Where P - Monthly payment i.e. $662 I - Monthly interest rate…
Q: A new car is purchased for $10,000 with a 0% down, 9% interest rate loan. The loan’s length is 4…
A: Using excel PV function
Q: Jake has approached you for a loan and based on your assessment, his cash-flow will accommodate a…
A: Loan is repaid in 5 years, on monthly basis. No. of repayments = 5yrs*12 = 60 Total Repayment = No.…
Q: A restaurant borrows $12,800 from a local bank for 5 months. The local bank charges simple interest…
A: Here, Borrowed Amount is $12,800 Interest Rate is 7.3% Time Period is 5 Months One month is equal to…
Q: Please do not answer this question in excel thank you in advance. A loan of $13,000 at 5.65%…
A: A loan is when one or more companies, organisations, or other entities lend money to other…
Q: o help open up a restaurant, Austin borrowed money from a bank. He took out a personal, amortized…
A: Amount Financed = $46500 Interest rate = 6.9% Years = 8 Interest Rate (r) = 6.9%/12 = 0.575% =…
Q: A new engineering graduate who started a business borrowed money for 1 year. The amount of the loan…
A: When a person is in a need of short-term borrowings he can take the amount short term borrowing by…
Q: Jane wants to buy a house and approaches the bank to borrow $638,000. The bank agrees to lend her…
A: A loan refers to a sum of the amount that is being borrowed by a borrower who is in need of funds…
Q: PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 3.- Andres Rosas wants to know how much…
A: Discounting is a technique through which present value (PV) of future cashflows is computed by using…
Q: To go on a summer trip, Bill borrows $500. He makes no payments until the end of 2 years, when he…
A: Here, Borrowed Amount is $500 Time Period is 2 years Interest Rate is 6% Interest Type is Simple…
Q: A car loan of $37,412.98 is to be repaid with end-of-month payments of $725.06. If interest is…
A: Loan amount (PV) = $37,412.98 Monthly payment (P) = $725.06 Interest rate = 5% Monthly interest rate…
Q: You have just purchased a car and taken out a $48,000 loan. The loan has a five-year term with…
A: In Installment payment system, loan in not paid collectively with interest due but interest and…
Q: Let's say you are a credit analyst in the asset management department of a large bank or insurance…
A: We are not allowed to use excel so the excel sheet cannot be attached but I have provided the…
Q: Athena took out a home loan 4 years ago with a 30-year term, monthly payments of $1,600, and an…
A: The given problem can be solved using FV and PMT function in excel. FV function will compute…
Q: Mark takes out a loan for $20,000. The loan has 2% interest rate and a 2.5% APR. Complete the…
A: The sum of the interest plus fees on this loan = Loan Amount * APR
Step by step
Solved in 4 steps with 1 images
- A borrower has two alternatives for a loan: (1) issue a $420,000, 30-day, 6% note or (2) issue a $420,000, 30-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ fill in the blank 2 for each alternative. Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $420,000, 30-day, 6% interest-bearing note: $ fill in the blank 3 (2) $420,000, 30-day note discounted at 6%: $ fill in the blank 4 Alternative 1 is more favorable to the borrower because the borrower receives more cash .4) You borrow $2500 on September 3rd this year. Your demand loan carries an interest rate of 7.46%. You make partial payments of $500 on October 15th and $1575 on November 17th, You want to make a final payment of the remaining outstanding balance on November 30tn. What is the size of your final payment? Use the declining balance method. A) $450.02 B) $399.76 C) $612.84 D) $851.11 E) $449The following loan was paid in full before its due date a) Find the value of h using an appropriate formula b) Use the actuarial method to find the amount of unearned interest c) Find the payoff amount Regular Monthly Payment # of Payments Remaining after Payoff APR 7.2% $247 8 What is the finance charge per $100 financed? h=$ (Round to the nearest cent)
- Use the ordinary interest method to compute the time (in days) for the loan. Round your answer up to the next highest day when necessary. Principal Rate (%) Time Interest $7,300 10.4 107 X days $227 Need Help? Read ItThe following loan was paid in full before its due date. a) Find the value of h using an appropriate formula. b) Use the actuarial method to find the amount of unearned interest. c) Find the payoff amount. Regular Monthly Payment APR # of Payments Remaining after Payoff 8.7% 4 $214 What is the finance charge per $100 financed? h = $ (Round to the nearest cent.) The unearned interest is about $ (Round to the nearest cent.) The payoff amount is $ Enter your answer in each of the answer boxes. f12 inser f9 f1o f7 fg f6 f4 f5 esc 5 7 8. %24 3 %23rive loan is below. Payments of $1,987.26 are made monthly. Payment # Payment 1 1,987.26 2 1,987.26 3 1,987.26 Interest Debt Payment Balance 1,604.17 383.09 1,602.41 384.85 1,600.65 386.61 Provide your answer below: X Y Z Calculate the value of z, the balance of the loan at the end of month 3. Give your answer to the nearest dollar. Do not include commas or the dollar sign in your answer.
- A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. < (1) $630,000, 75-day, 6% interest-bearing note: $ (2) $630,000, 75-day note discounted at 6%: $ c. Alternative is more favorable to the borrower because the borrowerPrepare the following calculations. principle on a note is $ 4,000, interest rate is 5%, time is 2 years. Interest? _______________. principle on a loan is $ 3,700, interest rate is 8%, time is 9 months. Interest? ______________. principle on note is $ 9,600, interest rate is 4%, time is 90 days. Interest? __________________. Sales are $1,600, cash discount terms are 2/10 n 30. paid in discount period. Sales discount ? _____________. remit? _____________________. sales are $ 3,800, returns are $ 850, cash discount terms are 3/15 n 45. paid in discount period. Sales discount? ______________________. Remit ? _____________________.A finance company uses the discount method of calculating interestThe loan principal is $4,500, the interest rate is 4.5%, and repayment is expected in one and half yearsYou will receive Type your answer here from the lender .
- In Excel Please show how to solve this and please show step by step how to solve to answer questions A. and B. . You borrow a Graduated Payment Mortgage (GPM) of $400,000 with monthly payments and 15-year term. The annual interest rate is 4%. The lender allows you to pay only 0.5 monthly PMT for the first 5 years and pay full monthly PMT thereafter. In other words, your payment factors are as follows: month 1-month 60: 50%; and month 61- month 180: 100%. Suppose that the origination cost of the loan is $5,000, please answer the following questions: A. What is your monthly payment for the first 5 years? B. What is your annual effective cost of the GPM if you hold the loan for an entire term?Find the amount (in of interest and the maturity value of the loans. Use the formula MV = P + I to find the maturity value. (Round your answers to two decimal places.) Principal Rate (%) Time $145,000 14/12/2 Need Help? Submit Answer Read It 8 months Interest Enter a number. Maturity Value LA XA payday loan provides short-term loans ranging from $250 to $2,000. Assume the cost of the loan is $1.00 per day per $100 borrowed until the loan is repaid. What is the APR for a $300 payday loan that is repaid in five days? 1.67 Need Help? Read It