Question: Please show work in excel. You are considering borrowing $50,000 on a 180-month loan. The annual interest rate on the loan depends on your credit

Please show work in excel. You are considering borrowing $50,000 on

Please show work in excel.

You are considering borrowing $50,000 on a 180-month loan. The annual interest rate on the loan depends on your credit score in the following fashion: Annual Rate 8.15 8.45 9 Credit Score 10 740-850 11 720-739 12 700-719 13 670-699 14 640-669 15 620-639 8.95 9.725 11.225 12.475 Write a formula that gives your monthly payments as a function of your credit score

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

# What is the Present Value PV if: Future Value = $2351 Interest rate=0.12 Number of periods = 18 Do not round intermediary calculations. Use full precision of your calculator or excel. Round final...

Please Show work in Excel Tire City, Inc. Income Statement - In Thousands ($000) Ratios: Cost of Sales % of Sales SG&A % of Sales Interest Expense % of Debt 0 Tax % of Taxable income 1 Cash % of...

Please Show work in excel. Tire City, Inc. Income Statement - In Thousands ($000) Ratios: Cost of Sales % of Sales SG&A % of Sales Interest Expense % of Debt 0 Tax % of Taxable income 1 Cash % of...

please show work in excel for problems 4,5,6 Walton Clothing, Inc. David decided to purchase the following equipment as of January 1, 2013. Cost The Business Situation Useful Life $7,500 5 yrs. After...

PLEASE SHOW WORK ON EXCEL PREFERRED Foster designer Inc., a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales...

Please help answer the following finance questions. Please show work in excel. Please show work in excel. Thanks 1. Ginger borrowed $350,000 at 5.25%. Her loan is for 30 years. How much will her...

Task 4 - Loans (Maximum 10 Marks) Learning Outcome A bank is considering giving a loan of 50 000 to a customer at a variable interest rate. The rate used to find the initial payment is (N + 1)% where...

Q1 A Q1 B Please show work in excel with formulas shown thank you! You have purchased a property using debt financing in the form of an accrual loan. The loan details are as follows: Loan amount...

Please show work in excel. Suppose you are considering the acquisition of a hotel. The building is currently leased for the next 5 years with annual (year-end) rents of $3,000,000. At the end of the...

Produce the Net Operating Income (NOI) Please show work in excel with formulas Youre considering investing in the following warehouse building, with the transaction expected to close on 1 January...

At what angle above the horizon is the Sun when light reflecting off a smooth lake is polarized most strongly?

Should an odd or even number of categories be used in an itemized rating scale?

Work with a partner or in a small group to answer these questions. The diagram shows two triangular prisms, A and B. A is a right-angled triangular prism. B is an isosceles triangular prism. a Will...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...