Question: please explain in excel with formulas showed The following information relates to Problems 1-2. You plan to borrow a fixed payment loan of $400,000 for

please explain in excel with formulas showed

The following information relates to Problems 1-2. You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The frequency of your periodic equal payments to be made in a year is 2. 1) What should be your periodic equal payment to your lender? Group of answer choices $17,343.28 $211,622.71 $104,858.38 $52,189.82 2) What will be the approximate modified duration of this fixed payment loan? Group of answer choices 1.238 2.000 1.192 1.215

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!

A developer of video game software has seven proposals for new games. Unfortunately, the company cannot develop all the proposals because its budget for new projects is limited to $950,000 and it has...

please solve this in excel with formula given The following information relates to Problems 1-2. You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The...

please solve this in excel, with formulas showed The following information relates to Problems 1-3. An investor purchases a nine-year, 7% annual coupon payment bond at a price equal to face value....

please answer and explain in excel The following informotion relates to Problems 1-2. You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The frequency of...

MULTIPLE CHOICE 1 Using the recurrence relation t0 = 8, tn+1 = tn + 9, the sixth term would be: A 2 15 B 17 C 23 D 53 E 62 A canoe costs $40 to hire for the first day and $30 for each extra day. If...

please explain in excel with formulas 1) You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The frequency of your periodic equal payments to be made in a...

Please help me balance my post closing balance!!!!! I don't know where I made my errors. Accounting Cycle Project Solid Footing 9e Project is Activated Save>SAVING your project following these...

I cannot seem to balance can you please help me. it is due tonight DelvaGuy-ACP View ome Insert Draw Page Layout Formulas 1. Xcut AH AH AH Copy este Format BI U S S. A AH x & fx Data Review = = 3...

please solve all the problems. Format Tools Data Window Help Espinal Mineis-ACP Excel File Edit View Insert BU Home insert Draw Page Layout Formulas Data Review View A- So Wrap Text B A aste Merge &...

70 SOLID FOOTING Chapter 7 - Adjusting Entries Now that all of January's transactions have been entered, it is time to prepare adjusting entries, Step 3 in the Accounting Cycle. By reviewing the...

i have completed the begining of journal. but still need the depreciations and expenses for the bottom of it. Can you alos fill out the general ledgers, trial balance , income statement snd statement...

A gas occupying a volume of 725 mL at a pressure of 0.970 atm is allowed to expand at constant temperature until its pressure reaches 0.541 atm. What is its final volume?

Two experiments are performed. In the first experiment a six-sided die is rolled 50 times and a 0 is scored twice. In the second experiment the die is rolled 100 times and a 0 is scored four times....

1 . Calculate the variable overhead spending and efficiency variances and indicate whether each is favorable ( F ) or unfavorable ( U ) . 2 . Calculate the fixed overhead spending and production -...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Technology. Your instructor has asked you to speak to the faculty club at your school. Your speech is to be about the benefits of membership in student organizations. You are unable to make the...

Seafood Specialties Restaurant offers a shrimp and lobster tail special each Friday evening.You are manager of the restaurant. On Tuesday, you received a request from a customer, Shipley Masters, who...

You are the customer service representative for Fly High Airline. The airline awards frequent flyer miles but charges a $50 fee per ticket unless the free flight is booked more than 14 days in...