Problem 1) use excel and provide the formulas used for those cells

(a) You are paying off a debt at a nominal 8% per year by paying $400 at the end of each of each quarter for the next year. Find the interest paid in the last $400 payment. (b) If this debt were to be paid off in two equal payments of $1650 at the end of this year and next year, find the interest paid in the first $1650 payment. Again the loan rattus a nominal 8% per year compounded quarterly. 1- 2- The Southern Guru Copper Company operates a large mine in a South American country. A legislator in the National Assembly said in a speech that most of the capital for the mining operation was provided by loans from the World Bank; in fact, Southern Guru has only $1.5 million of its own money actually invested in the property. The cash flow for the mine is: Year Cash Flow 0 $-0.5M 1 $0.9M 2 $3.5M 3 $3.9M 4 $8.6M 5 $4.3M 6 $3.1M 7 $1.2M The legislator divided the $25.5 million total profit by the $1.5 million investment. This produced he said, a 1700% rate of return on the investment. Southern Guru, claiming the actual rate of