DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period.What is the amount of the annual payment? A) $120,480.90 B) $85,442.71 C) $276,000.00 D) $361,442.71 (Choose one option)
DO IT IN EXCEL, AND SHOW THE FORMULAS If the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period.What is the amount of the annual payment? A) $120,480.90 B) $85,442.71 C) $276,000.00 D) $361,442.71 (Choose one option)
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 5PA: Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated...
Related questions
Question
2.-
DO IT IN EXCEL, AND SHOW THE FORMULAS
If the company purchases the machine, its cost of $276,000 will be financed with a loan at 14.8% interest for three years requiring equal annual payments including principal and interest. The machine will be depreciated at 20% per year. The company will pay $8,000 per year for maintenance services. The company plans to keep the machine even after its payback period.What is the amount of the annual payment?
A) $120,480.90
B) $85,442.71
C) $276,000.00
D) $361,442.71
(Choose one option)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning