Homework Help is Here – Start Your Trial Now!
Business
Accounting
A B C E 1 Year Asset Value 2 2001 192,793 3 2003 224,803 4 2004 202,542 5 2005 199,643 6 2007 219,446 7 2010 213,776 8 2011 245,293 2013 231,390 2015 269,319 2017 310,521 2020 354,112 Instructions: In the "Forecast" area below the data, use the FORECAST. LINEAR function to predict the value of the asset in the given years. Start in Cell D14. For the value of x, select the cell containing the year we want to forecast (cell C14). The "Known Ys" are the known asset values, and the "Known Xs" are the known years. Select the corresponding data ranges as absolute references. Copy the formula down to all years. In the "Round up Forecast" area below the data, combine the ROUND and FORECAST.LINEAR functions to predict the value of the asset in the given years. Imbed the FORECAST.LINEAR function (exactly the same criteria as above) within the ROUND function. Return values rounded to the nearest thousand dollars. 10 11 12 13 14 Forecast: 2021 15 2025 16 2030 17 2035 18 19 Round up forecast: 2021 20 2025 21 2030 22 2035 + 23 24

A B C E 1 Year Asset Value 2 2001 192,793 3 2003 224,803 4 2004 202,542 5 2005 199,643 6 2007 219,446 7 2010 213,776 8 2011 245,293 2013 231,390 2015 269,319 2017 310,521 2020 354,112 Instructions: In the "Forecast" area below the data, use the FORECAST. LINEAR function to predict the value of the asset in the given years. Start in Cell D14. For the value of x, select the cell containing the year we want to forecast (cell C14). The "Known Ys" are the known asset values, and the "Known Xs" are the known years. Select the corresponding data ranges as absolute references. Copy the formula down to all years. In the "Round up Forecast" area below the data, combine the ROUND and FORECAST.LINEAR functions to predict the value of the asset in the given years. Imbed the FORECAST.LINEAR function (exactly the same criteria as above) within the ROUND function. Return values rounded to the nearest thousand dollars. 10 11 12 13 14 Forecast: 2021 15 2025 16 2030 17 2035 18 19 Round up forecast: 2021 20 2025 21 2030 22 2035 + 23 24

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
A B C E 1 Year Asset Value 2 2001 192,793 3 2003 224,803 4 2004 202,542 5 2005 199,643 6 2007 219,446 7 2010 213,776 8 2011 245,293 2013 231,390 2015 269,319 2017 310,521 2020 354,112 Instructions: In the "Forecast" area below the data, use the FORECAST. LINEAR function to predict the value of the asset in the given years. Start in Cell D14. For the value of x, select the cell containing the year we want to forecast (cell C14). The "Known Ys" are the known asset values, and the "Known Xs" are the known years. Select the corresponding data ranges as absolute references. Copy the formula down to all years. In the "Round up Forecast" area below the data, combine the ROUND and FORECAST.LINEAR functions to predict the value of the asset in the given years. Imbed the FORECAST.LINEAR function (exactly the same criteria as above) within the ROUND function. Return values rounded to the nearest thousand dollars. 10 11 12 13 14 Forecast: 2021 15 2025 16 2030 17 2035 18 19 Round up forecast: 2021 20 2025 21 2030 22 2035 + 23 24
Transcribed Image Text:A B C E 1 Year Asset Value 2 2001 192,793 3 2003 224,803 4 2004 202,542 5 2005 199,643 6 2007 219,446 7 2010 213,776 8 2011 245,293 2013 231,390 2015 269,319 2017 310,521 2020 354,112 Instructions: In the "Forecast" area below the data, use the FORECAST. LINEAR function to predict the value of the asset in the given years. Start in Cell D14. For the value of x, select the cell containing the year we want to forecast (cell C14). The "Known Ys" are the known asset values, and the "Known Xs" are the known years. Select the corresponding data ranges as absolute references. Copy the formula down to all years. In the "Round up Forecast" area below the data, combine the ROUND and FORECAST.LINEAR functions to predict the value of the asset in the given years. Imbed the FORECAST.LINEAR function (exactly the same criteria as above) within the ROUND function. Return values rounded to the nearest thousand dollars. 10 11 12 13 14 Forecast: 2021 15 2025 16 2030 17 2035 18 19 Round up forecast: 2021 20 2025 21 2030 22 2035 + 23 24
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS