Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Evaluating alternative notes The data for two alternatives for a loan are provided in the table below. DATA Number of days per year 360 Alternative
Evaluating alternative notes | ||||
The data for two alternatives for a loan are provided in the table below. | ||||
DATA | ||||
Number of days per year | 360 | |||
Alternative 1 | Alternative 2 | |||
Principal amount of note | $510,000 | $510,000 | ||
Interest rate | 4% | |||
Note discount rate | 4% | |||
Term of note, days | 90 | 90 | ||
Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (D15:D17) into the appropriate fields in CNOWv2 for grading. | ||||
Amount | Formulas | |||
a. | Amount of the interest expense for each alternative | |||
b. | Proceeds received by the borrower under alternative 1 | |||
Proceeds received by the borrower under alternative 2 | ||||
-
Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar.
$( ) for each alternative.
-
Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar.
(1) $510,000, 90-day, 4% interest-bearing note: $ ( )
(2) $510,000, 90-day note discounted at 4%: $ ( )
-
Alternative (1 or 2) is more favorable to the borrower because the borrower ( receives more cash / Pays more interest/ has an extension of time to pay)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started