Question: please provide the answer in excel spreadsheet 2- Rob is faced with choosing between two loans. Loan A is available for $80,000 at 7% for

please provide the answer in excel spreadsheet

2- Rob is faced with choosing between two loans. Loan A is available for $80,000 at 7% for 30 years, with 6 points to be including in closing costs. Loan B would be for the same amount, but with 8% interest for 30 years, with 3 points to be included in the closing costs. Both loans will be fully amortizing a. If the loan is repaid after 20 years, which loan would be the better choice? b. If the loan is repaid after 5 years, which loan would be the better choice

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!

Complete/answer each of the following problems providing an Excel spreadsheet with the solution to receive full credit. For example, create the loan amortization table for each of the problems. 1-...

Rob is faced with choosing between two loans. Loan A is available for $80,000 at 7% for 30 years, with 6 points to be including in closing costs. Loan B would be for the same amount, but with 8%...

???????answerwithout using excel 16. A borrower is faced with choosing between two loans. Loan A is available for $ \$ 75,000 $ at 6 percent interest for 30 years, with 6 points to be included in...

both parts A&B please. need asap A borrower is faced with choosing between two loans. Loan A is available for $84,000 at 6 percent interest for 30 years, with 6 points to be included in closing...

A borrower is faced with choosing between two loans. Loan A is available for $ 8 3 , 0 0 0 at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B would be made for...

A borrower is faced with choosing between two loans. Loan A is available for $ 7 5 , 0 0 0 at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B would be made for...

13. John wants to buy a property for $105,000 and wants an 80 percent loan for $84,000. A lender indicates that a fully amortizing loan can be obtained for 30 years ( 360 months) at 6 percent...

How do you find and calculate the answers on 1 and 2 on Microsoft excel? The answered are in bold. A borrower is faced with choosing between two loans. Loan A is available for $75,000 at 6 percent...

SHOW CLEAR WORK ON EXCEL A borrower is faced with choosing between two loans. Loan A is available for $75,000 at 6 percent interest for 30 years, with 6 points to be included in closing costs. Loan B...

A borrower is faced with choosing between two loans. Loan A is available for $ 8 0 , 0 0 0 at 6 percent interest for 3 0 years, with 6 points to be included in closing costs. Loan B would be made for...

The Beer-Lambert law relates the absorbance A of a solution to the concentration C of a species in solution by A = MLC, where L is the path length and M is the molar absorption coefficient. Assume...

Explain the term opportunity cost with respect to the cost of funds to the firm.

What is the name of Google's language model that aims to support 1 , 0 0 0 languages? Multiple Choice Polyglot Translation Model ( PTM ) Multilingual Language Model ( MLLM ) Universal Speech Model (...

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...