Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. problem 1) use excel and provide the formulas used

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

80.2K

Verified Solution

Question

Accounting

Problem 1) use excel and provide the formulas used for those cells image
(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!
Become a Member

Other questions asked by students

Physics
1.2K views

The heavy boy and light girl are balanced on the seesaw. If they both move inward...

Finance
1.2K views

Work in Process—Assembly Department Bal., 3,000 units, 25% completed 8,625 / To Finished Goods, 69,000 units Direct materials,...

Biology
1.2K views

In her chapter on the IVF industry Jain highlights all of the following ideas ascribed...

Biology
1.2K views

Which type of muscles has multinucleated fibers or cells Select one O a oblique muscles...

Physics
1.2K views

50 In Young s double slit interference experiment if the n bright fringe for light...

Geometry
1.2K views

Solve for the value of a 67 6a 1 Answer Attempt 1 out of 2

Statistics
1.2K views

The following graph shows the median earnings for females from 2005 to 2009 in constant...

Algebra
1.2K views

A Given the above Triangle If a 12 c 16 then the tan A cot...

Accounting
1.2K views

As a new controller, reply to this comment by a plant manager: "As i see...

Accounting
1.2K views

Exercise 7-13 Honoring a note LO P4 Following are selected transactions for Vitalo Company. Nov....

Accounting
1.2K views

Raner, Harris and Chan is a consulting firm specializing in information systems for medical and...

Finance
1.2K views

Given the following interest rates for borrowing and lending, answer the following questions: ...