Please use Excel to answer these question and please write down the formulas used
(a) You are paying off a debt at a nominal 8% per year by paying S400 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 S1650 payment. Again the loan rate is 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 low $0.5M 1 $0.9M 2$3.5M 3 $3.9M 4 $8.6M $4.3NM 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 return is much lower, asks you to compute it. 3- A young engineer's starting salary is $52,000. The engineer expects annual raises of 3%. T engineer will deposit 10% of the annual salary at the end of each year in a savings account that earns 4%. How sugsest that the spreadsheet include deposit, and the year's cumulative savings. business after 15 years? We at least columns for the year, the year's salary, the year's much will the engineer have saved for starting a (a) You are paying off a debt at a nominal 8% per year by paying S400 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 S1650 payment. Again the loan rate is 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 low $0.5M 1 $0.9M 2$3.5M 3 $3.9M 4 $8.6M $4.3NM 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 return is much lower, asks you to compute it. 3- A young engineer's starting salary is $52,000. The engineer expects annual raises of 3%. T engineer will deposit 10% of the annual salary at the end of each year in a savings account that earns 4%. How sugsest that the spreadsheet include deposit, and the year's cumulative savings. business after 15 years? We at least columns for the year, the year's salary, the year's much will the engineer have saved for starting a
