Evaluating alternative notes Abouwer has two tomates for a loan: (1) 210.000 90 day, note or issue a $250.000, 90-day note that the creditor discounts at Astume 360-day year This information has been collected in the Microsoft Excel Online di Open the spreadsheet, perform the required analysis, and input your answers in the questions below Open spacht Calcate the amount of the interest expense for each otion Round your answer to the rest donc 3 for each alternative b. Determine the proceeds received by the brooch brave Round your answers to the nearest dollar (1) 210,000, 9-day, 6 interest-bearing notes 121 R210,000, 90-day not discounted at 6:$ Amative is more favorable to the borrower because the borrower Excel template - Saved Search (Alt +Q) File Home Insert Draw Page Layout Formulas Data Review View Help Arial V 10 10 B B Av vabe Currency D15 A E 1 B Evaluating alternative notes The data for two alternatives for a loan are provided in the table below. 2 3 4 5 6 789 DATA Number of days per year 360 Alternative 1 Alternative 2 7 Principal amount of note $210,000 $210,000 Interest rate 6% 9 Note discount rate 6% 10 Term of note, days 90 90 11 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:017) into the appropriate fields in CNOWV2 for grading 12 13 Amount Formulas . 14 15 Amount of the interest expense for each alternative 16 b. Proceeds received by the borrower under alternative 1 17 Proceeds received by the borrower under alternative 2 18 19 20 21 > Data +