Problem 1) use excel and provide the formulas used for those cells ...
80.2K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
