SHOW ONLY IN EXCEL.

NO Hard coded formulas. I will rate

Provided but rate decreases, it is advantaylor nance at the new, lower market rate. Note: The data for these exercises can be found on the Benninga, Princi of Finance with Excel, Third Edition companion website (www.oup.com/us/ Benninga). 1. (Leverage) Your friend presents you with the following deal: You can buy a box for $9, decorate it at a cost of $1, and sell it in 1 year for $11. a. You have $100 to invest in the boxes (and decorations). What are your profits assuming the deal goes through? What is the return in percentage on your investment? b. Suppose that in addition to your own $100. you can borrow $900 al 5% interest. The whole amount of $1,000 will be invested in boxes. CHAPTER 4 Loans and Amortization Tables 133 c. What are your profits assuming the deal goes through? What is the return in percentage on your investment? Assume you borrowed the $900 carrying a 5% interest rate for the deal period, bought the boxes and decorated them, but you have just found out that the market price of the decorated boxes has dropped to $8.5. What are your profits/losses in dollars? What is the return in percentage on your investment? Intonat anu 1., lan amortization table. You are taking an interest