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 ...

70.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

Q

The state? lottery's million-dollar payout provides for ?$1 ?million(s) to be paid over 19 years in...

Finance
Q

1. Which of the following slightly soluble substances are more soluble in acidic solution: AgCl AgCN...

Chemistry
Q

The calcium supplements taken by many women are composed primarily of powdered calcium carbonate, CaCO3, which...

Chemistry
Q

PCR takes advantage of the steps of DNA replication. Match each step of PCR with the...

Biology
Q

A food processor uses approximately 27,000 glass jars a month for its fruit juice product. Each...

General Management
Q

2 The effective resistance between B and C of letter A containing resistances as shown...

Physics
Q

Find the exact value of the expression without the use of a calculator cos 45...

Basic Math
Q

How do i do part A and part B. On 1 July...

Accounting
Q

Question 4[18 points] Southgate Inc. made 35,500 units during July, using 32,300 direct...

Accounting
Q

Suntech Distributors, Inc., deposits $4,000 at the beginning of each 3-month period for 7 years...

Accounting
Q

You are considering a 10-year, $1,000 par value bond. Its coupon rate is 8%, and...

Finance
Q

The determination of cost behavior is called cost prediction

Accounting