Sellers Construction Company purchased a compressor for $102,400 cash. It had an estimated useful life of four years and a $9,800 salvage value. At the beginning of the third year of use, the company spent an additional $8,190 related to the equipment. The company's financial condition just prior to this expenditure is shown in the following statements model: Balance Sheet Assets Cash + 12,310 + Book Value of Compressor 56,100 Stockholders' Equity Retained • Common Stock + Earnings 22,400 46,010 Income Statement Statement of Revenue + NA Expense NA = Net Income Cash Flows NA NA Required Record the $8,190 expenditure in the statements model under each of the following independent assumptions: Note: In the Statement of Cash Flows column, use the initials "OA" for operating activities, "FA" for financing activities, and "IA" for investing activity. Enter any decreases to account balances and cash outflows with a minus sign. Not all cells require input. a. The expenditure was for routine maintenance. b. The expenditure extended the compressor's life. c. The expenditure improved the compressor's operating capacity. Sellers Construction Company a. b. C Horizontal Statements Model Balance Sheet Income Statement Assets Stockholders' Equity Statement of Cash Net Cash + Book Value of Compressor Common Stock Retained Earnings Revenue Expenses Flows Income 12,310 + 56,100 = 22,400 + 46,010 + = = + ++
Sellers Construction Company purchased a compressor for $102,400 cash. It had an estimated useful life of four years and a $9,800 salvage value. At the beginning of the third year of use, the company spent an additional $8,190 related to the equipment. The company's financial condition just prior to this expenditure is shown in the following statements model: Balance Sheet Assets Cash + 12,310 + Book Value of Compressor 56,100 Stockholders' Equity Retained • Common Stock + Earnings 22,400 46,010 Income Statement Statement of Revenue + NA Expense NA = Net Income Cash Flows NA NA Required Record the $8,190 expenditure in the statements model under each of the following independent assumptions: Note: In the Statement of Cash Flows column, use the initials "OA" for operating activities, "FA" for financing activities, and "IA" for investing activity. Enter any decreases to account balances and cash outflows with a minus sign. Not all cells require input. a. The expenditure was for routine maintenance. b. The expenditure extended the compressor's life. c. The expenditure improved the compressor's operating capacity. Sellers Construction Company a. b. C Horizontal Statements Model Balance Sheet Income Statement Assets Stockholders' Equity Statement of Cash Net Cash + Book Value of Compressor Common Stock Retained Earnings Revenue Expenses Flows Income 12,310 + 56,100 = 22,400 + 46,010 + = = + ++
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 14M
Related questions
Question
am. 102.
![Sellers Construction Company purchased a compressor for $102,400 cash. It had an estimated useful life of four years and a $9,800
salvage value. At the beginning of the third year of use, the company spent an additional $8,190 related to the equipment. The
company's financial condition just prior to this expenditure is shown in the following statements model:
Balance Sheet
Assets
Cash +
12,310 +
Book Value of
Compressor
56,100
Stockholders' Equity
Retained
• Common Stock + Earnings
22,400
46,010
Income Statement
Statement of
Revenue
+
NA
Expense
NA
=
Net Income Cash Flows
NA
NA
Required
Record the $8,190 expenditure in the statements model under each of the following independent assumptions:
Note: In the Statement of Cash Flows column, use the initials "OA" for operating activities, "FA" for financing activities, and "IA" for
investing activity. Enter any decreases to account balances and cash outflows with a minus sign. Not all cells require input.
a. The expenditure was for routine maintenance.
b. The expenditure extended the compressor's life.
c. The expenditure improved the compressor's operating capacity.
Sellers Construction Company
a.
b.
C
Horizontal Statements Model
Balance Sheet
Income Statement
Assets
Stockholders' Equity
Statement of Cash
Net
Cash
+
Book Value of
Compressor
Common
Stock
Retained
Earnings
Revenue
Expenses
Flows
Income
12,310 +
56,100 =
22,400 +
46,010
+
=
=
+
++](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4cc6232a-fd4c-44fc-a3e0-1ea3660d9ffc%2Fbad5ab66-2f1d-43bf-8642-4bc2629e8037%2F47p695e_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Sellers Construction Company purchased a compressor for $102,400 cash. It had an estimated useful life of four years and a $9,800
salvage value. At the beginning of the third year of use, the company spent an additional $8,190 related to the equipment. The
company's financial condition just prior to this expenditure is shown in the following statements model:
Balance Sheet
Assets
Cash +
12,310 +
Book Value of
Compressor
56,100
Stockholders' Equity
Retained
• Common Stock + Earnings
22,400
46,010
Income Statement
Statement of
Revenue
+
NA
Expense
NA
=
Net Income Cash Flows
NA
NA
Required
Record the $8,190 expenditure in the statements model under each of the following independent assumptions:
Note: In the Statement of Cash Flows column, use the initials "OA" for operating activities, "FA" for financing activities, and "IA" for
investing activity. Enter any decreases to account balances and cash outflows with a minus sign. Not all cells require input.
a. The expenditure was for routine maintenance.
b. The expenditure extended the compressor's life.
c. The expenditure improved the compressor's operating capacity.
Sellers Construction Company
a.
b.
C
Horizontal Statements Model
Balance Sheet
Income Statement
Assets
Stockholders' Equity
Statement of Cash
Net
Cash
+
Book Value of
Compressor
Common
Stock
Retained
Earnings
Revenue
Expenses
Flows
Income
12,310 +
56,100 =
22,400 +
46,010
+
=
=
+
++
AI-Generated Solution
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![College Accounting, Chapters 1-27](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Survey of Accounting (Accounting I)](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
![College Accounting, Chapters 1-27](https://www.bartleby.com/isbn_cover_images/9781337794756/9781337794756_smallCoverImage.gif)
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,