AutoSave OFF Home Insert Draw Design Layout A^ A Paste 92 Page 1 of 2 Garamond B I U 748 words V 12 2 V ab xx A v References Aa English (United States) Po V 1 Mailings Review View Test #2 2 665 = A W= TEST #2 FNB 100 Spring 2023 Tell me V AaBbCcDdEe Normal AaBbCcDdEe No Spacing Aa BbCcDc Heading 1 AaBb CcDdE Heading 2 Chapters 4, 5 & 6 April 10/ GIVER April 21 Due April 24 midnight FNB 100-081W-8408 / FNB 100H-081W-8413 FNB 100-130W-8406 / FNB 100H-130W-8412 FNB 100-0503-7475 / FNB 100H-0503-7474 Why do you borrow? Construct a spreadsheet that would indicate the profit rate and profit in dollars if you purchase given amount of items and you sell it, allowing the selling price to be variable for different amount of items and also 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. Aa BbCcDdEe 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. 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 fully in all alternatives in the same spreadsheet. Mark with a background color the cells that you used in order to drag the information completing the work. Specify the cells that you can use for all the alternatives you need. 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. 3 Refinancing or not? In a period of changing financial environment as the current one, because we need to deal with inflationary pressures interest rates are increasing. If you have a loan such as the one your provided in the above case (2) and after five years interest rates may change - 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 five years after the loan interest rates change. Accessibility: Good to go Heading 3 Focus Styles Pane !!!!! Comments Dictate Sensitivity Editor il Editing I Share 30 + 143%