Suppose a company's cost of goods sold for years 2 and 3 were $283,310 and $299,390 respectively. Also suppose that inventory had a balance of $34,740 at the end of year 1, $35,168 at the end of year 2, and $36,356 at the end of year 3. If the annual growth in total revenues is 8.42% for the foreseeable future, calculate the forecasted inventory balance at the end of year 5. Assume the same inventory turnover in all future years as that in year 3 calculated using the average asset balances. Also assume the same gross margin % in all future years as that in year 3. Note that year 3 is the latest year with reported results, while years 4 onwards are all forecasted years.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 46E
icon
Related questions
Question
Suppose a company's cost of goods sold for
years 2 and 3 were $283,310 and $299,390
respectively. Also suppose that inventory had
a balance of $34,740 at the end of year 1,
$35,168 at the end of year 2, and $36,356 at
the end of year 3. If the annual growth in total
revenues is 8.42% for the foreseeable future,
calculate the forecasted inventory balance at
the end of year 5. Assume the same inventory
turnover in all future years as that in year 3
calculated using the average asset balances.
Also assume the same gross margin % in all
future years as that in year 3. Note that year 3
is the latest year with reported results, while
years 4 onwards are all forecasted years.
Transcribed Image Text:Suppose a company's cost of goods sold for years 2 and 3 were $283,310 and $299,390 respectively. Also suppose that inventory had a balance of $34,740 at the end of year 1, $35,168 at the end of year 2, and $36,356 at the end of year 3. If the annual growth in total revenues is 8.42% for the foreseeable future, calculate the forecasted inventory balance at the end of year 5. Assume the same inventory turnover in all future years as that in year 3 calculated using the average asset balances. Also assume the same gross margin % in all future years as that in year 3. Note that year 3 is the latest year with reported results, while years 4 onwards are all forecasted years.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning