AutoSave one in TEST #2 FNB1DO Spring 2023 Home Insert Draw Design Layout References Mailings Review View 9 Tell me Cl Comments aming a Share 1 A y El V Ga'a'mm' V 12 V A A A3 V A0 AaBchDdEe AaEhCEDdEe AaBchDt AaBchDdEt AaBchDdEe > (g Q; g Paste 5 5 I U v ab x2 x7 A V p v A v Normal No Spacing Headin91 Heading 2 Heading 3 Styles Dictate Sensiuwty Editor _ _ Pane Test # 2 Chapters 4, 5 8: 6 April 10/ GIV'ER April 21 Due April 24 midnight FNB 100081W-8408 / FNB 100H-081W8413 FNB 100~13OW~8406 / FNB 100H~130W~8412 FNB 100-0503-7475 / FNB 100H-OSO37474 1 Why do you borrow? Construct a spreadsheet that would indicate the prot rate and prot in dollars if you purchase given iamount of items and you sell it, allowing the selling price to be variable for different amount of items an 9 to have some items not sold at all' Indicate that you may borrow some portion of the value you need for your purchase, that may vary from not borrowing anything to borrow all your capital. The selling price may be higher or lower of the purchased price. Use the formula FORMULATEXT #) to have the formulas visible to the person that views your work. Explain the meaning of the formulas used in clear and detailed manner. Provide an explanation of how you can use the code you made in EXCEL and what conclusions you reach out. 2 Amortization table for the cases that the same value is paid throughout the loan period and at the last period the total remaining balance is paid? Construct a spreadsheet that a given value of a loan for twenty years paid annually and a given interest rate is paid fule in all alternatives in the same spreadsheet. Mark with a background color the cells that you used i.n__r_)_r_(_i_e1:_tr_)_ drag the information completing the work. Specify the cells that you can use for all the alternatives you need. Use the formula FORMUmTEXTg#) to have the formulas visible to the person that views your work. Explain the meaning of the formulas used in clear and detailed manner. 3 Renancing or not? In a period of changing financial environment as the current one, because we need to deal with inationary pressures interest rates are increasing. If you have a loan such as the one your provided in the above case (2) and after ve years interest rates may change 7 we observe increases of the interest rates now, but in different time periods we experienced in the past we watched a decline in interest rates. How would you deal with the fact that ve years after the loan interest rates change. Page 1 of 2 748 words [IE English (United States) Accessibility: Good to go :1 Focus l l E0 :'_= __ .+143%