Eight years ago, Ohio Valley Trucking purchased a large-capacity dump truck for $110,000 to provide short-haul earth- moving services. The company sold it today for $45,000. Operating and maintenance costs averaged $12,200 per year. A complete overhaul at the end of year 4 costs an extra $3600. If i = 8% per year, write a single-cell function to display the annual cost.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter10: Short-term Decision Making
Section: Chapter Questions
Problem 3PB: Cinnamon Depot bakes and sells cinnamon rolls for $1.75 each. The cost of producing 500,000 rolls in...
icon
Related questions
Question

Please check answer -27504.3111

Eight years ago, Ohio Valley Trucking purchased a large-capacity dump truck for $110,000 to provide short-haul earth-
moving services. The company sold it today for $45,000. Operating and maintenance costs averaged $12,200 per year. A
complete overhaul at the end of year 4 costs an extra $3600.
If i = 8% per year, write a single-cell function to display the annual cost.
Multiple Choice
-PMT(8%, 4, –110000, 3600) – 12200 – PMT(8%, 4, ,-PV(8%, 4, –45000))
= -PMT(8%, 8, –12200, 45000) – 110000 – PMT(8%, 8, –PV(8%, 4, , –3600))
= -PMT(8%, 4, -110000, 3600) – 12200 – PMT(8%, 8, –PV(8%, 8, , –45000))
:-PMT(8%, 8, –110000, 45000) – 12200 – PMT(8%, 8, –PV(8%, 4, , –3600))
Transcribed Image Text:Eight years ago, Ohio Valley Trucking purchased a large-capacity dump truck for $110,000 to provide short-haul earth- moving services. The company sold it today for $45,000. Operating and maintenance costs averaged $12,200 per year. A complete overhaul at the end of year 4 costs an extra $3600. If i = 8% per year, write a single-cell function to display the annual cost. Multiple Choice -PMT(8%, 4, –110000, 3600) – 12200 – PMT(8%, 4, ,-PV(8%, 4, –45000)) = -PMT(8%, 8, –12200, 45000) – 110000 – PMT(8%, 8, –PV(8%, 4, , –3600)) = -PMT(8%, 4, -110000, 3600) – 12200 – PMT(8%, 8, –PV(8%, 8, , –45000)) :-PMT(8%, 8, –110000, 45000) – 12200 – PMT(8%, 8, –PV(8%, 4, , –3600))
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT