4-3 Project one
xlsx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240 APPLIE
Subject
Finance
Date
Jun 3, 2024
Type
xlsx
Pages
4
Uploaded by DoctorTurtle5212
Region
State
County
listing price $'s per square foot
square feet
Random
West North Central
ks
sedgwick
$ 303,400 $194 1,563 0.090167
West South Central
ar
faulkner
$ 280,500 $129 2,168 0.222218
Northeast
ny
cayuga
$ 265,400 $166 1,602 0.020073
South Atlantic
nc
brunswick
$ 281,000 $155 1,818 0.378145
Mountain
nm
chaves
$ 390,200 $204 1,915
0.61084
East South Central
tn
rutherford
$ 159,900 $87 1,847 0.525483
Mountain
co
pueblo
$ 225,200 $154 1,462 0.400903
Mountain
nm
curry
$ 307,900 $158 1,953 0.878967
Mountain
id
kootenai
$ 351,300 $229 1,536 0.255521
East South Central
ky
hopkins
$ 208,000 $104 2,007
0.47736
West South Central
la
st. charles
$ 171,400 $99 1,724 0.516153
South Atlantic
fl
okaloosa
$ 879,200 $142 6,196 0.198462
Pacific
wa
king
$ 405,700 $225 1,800 0.954023
East South Central
tn
hawkins
$ 269,000 $113 2,385 0.587954
Mid Atlantic
va
chesapeake city $ 343,400 $221 1,555 0.292419
Pacific
or
marion
$ 419,300 $217 1,936 0.757433
West South Central
tx
guadalupe
$ 263,800 $146 1,804 0.234878
South Atlantic
nc
edgecombe
$ 349,400 $170 2,061 0.365995
East South Central
ky
mccracken
$ 229,300 $126 1,824 0.372484
New England
ct
litchfield
$ 324,800 $194 1,673 0.266155
South Atlantic
fl
miami-dade
$ 792,900 $165 4,810 0.852385
South Atlantic
fl
highlands
$ 274,600 $166 1,650 0.252221
West North Central
mn
goodhue
$ 340,200 $148 2,296 0.612688
East South Central
tn
blount
$ 308,500 $135 2,278 0.125591
South Atlantic
fl
marion
$ 560,200 $151 3,717 0.953954
West North Central
mo
st. louis
$ 440,100 $197 2,229 0.897047
Northeast
ny
richmond
$ 320,600 $170 1,887 0.878345
West North Central
ia
polk
$ 393,600 $192 2,048 0.543452
West South Central
tx
harris
$ 196,200 $115 1,700 0.571739
West North Central
mn
st. louis
$ 337,200 $163 2,066
0.83673
East North Central
il
la salle
$ 311,100 $154 2,015 0.326436
Mid Atlantic
va
james city
$ 271,300 $209 1,296 0.365206
South Atlantic
nc
beaufort
$ 411,900 $190 2,163 0.638652
Pacific
wa
cowlitz
$ 420,400 $227 1,856 0.977125
Mid Atlantic
va
loudoun
$ 259,000 $179 1,450 0.636688
Pacific
wa
benton
$ 443,000 $247 1,790 0.057435
Northeast
pa
beaver
$ 315,300 $157 2,010
0.54453
West South Central
ok
creek
$ 362,200 $157 2,305 0.751833
South Atlantic
sc
orangeburg
$ 305,400 $172 1,780 0.346217
Mountain
co
la plata
$ 434,700 $202 2,151 0.043216
Northeast
ny
chemung
$ 614,600 $153 4,022 0.746879
Mid Atlantic
va
richmond city
$ 339,800 $177 1,915 0.973509
Pacific
ca
butte
$ 406,200 $217 1,875 0.466385
East South Central
ky
jessamine
$ 174,900 $98 1,777 0.970061
Mid Atlantic
va
montgomery
$ 277,500 $247 1,122 0.752061
Mountain
mt
missoula
$ 370,300 $177 2,091
0.21894
New England
nh
merrimack
$ 340,300 $198 1,715 0.175727
New England
nh
belknap
$ 397,300 $181 2,196 0.389303
Northeast
pa
lehigh
$ 305,800 $194 1,579 0.135652
East North Central
oh
sandusky
$ 253,900 $146 1,738 0.834504
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
SAMPLE
Sq Ft Area
Listing Price
Mean
2,087 $ 348,142 Median
1,881 $ 322,700 Std Dev.
862.78054627
$ 134,977.22 NATIONAL
Sq Ft Area
Listing Price
Mean
2111 $ 342,365 Median
1881 $ 318,000 Std Dev.
921 $ 125,914 R
0.8618147996
R-squared
0.7427247487
Slope
134.83
Intercept
66744
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
$- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 f(x) = 134.826130956397 x + 66743.685558285
R² = 0.742724748740012
Scatterplot
Square Feet
Listing Price
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
Related Documents
Related Questions
City of Smithville
General Fund
Operating statement account balances
For year 2023
Estimated Revenues Dr(Cr)
Revenues Dr(Cr)
Balance Dr(Cr)
Acct 3020/4020
Estimated Revenues-Property Taxes
$1,877,413
$1,877,578
($165)
Acct 3030/4030
Estimated Revenues-Sales Taxes
1,578,000
1,579,203
(1,203)
Acct 3040/4040
Estimated Revenues-Interest and Penalties on Taxes
15,000
12,571
2,429
Acct 3050/4050
Estimated Revenues-Licenses and Permits
500,000
497,960
2,040
Acct 3060/4060
Estimated Revenues-Fines and Forfeits
175,000
173,590
1,410
Acct 3070/4070
Estimated Revenues-Intergovernmental Revenue
789,000
789,000
0
Acct 3080/4080
Estimated Revenues-Charges for Services
659,720
661,253
(1,533)
Acct 3090/4090
Estimated Revenues-Miscellaneous Revenues
91,300
91,250
50
Encumberances Dr(Cr)
Expenditures Dr(Cr)
Appropriations Cr(Dr)
Available Balance Cr(Dr)
Acct 5020 / 6020 / 7020
Appropriations-General…
arrow_forward
Sh18
Please help me
Solution
Thankyou.
arrow_forward
r
0
Chesterfield County had the following transactions.
a. A budget is passed for all ongoing activities. Revenue is anticipated to be $1,023,250, with approved spending of $611,000 and
operating transfers out of $336,000.
Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does
b. A contract is signed with a construction company to build a new central office building for the government at a cost of $9,000,000.
The county previously recorded the budget for this project.
c. Bonds are issued for $9,000,000 (face value) to finance construction of the new office building.
d. The new building is completed. An invoice for $9,000,000 is received by the county and paid.
e. Previously unrestricted cash of $1,600,000 is set aside by county officials to begin paying the bonds issued in (c).
f. A portion of the bonds comes due, and $1,600,000 is paid. Of this total, $115,000 represents interest. The interest had not been
previously accrued.
g.…
arrow_forward
Countywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments
for the year just ended follow.
Metro
Suburban
Service revenue
$ 1,150,000
Variable expenses
190,000
$ 950,000
140,000
Controllable fixed expenses
Fixed expenses controllable by others
410,000
220,000
330,000
190,000
Outlying
$ 550,000
90,000
160,000
80,000
In addition to the expenses listed above, the company has $145,000 of common fixed expenses. Income-tax expense for the year is
$345,000.
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Incorporated.
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INCORPORATED
Segments of Company
Countywide
Cable Services
Metro
Suburban
Outlying
Segment contribution margin
Profit margin controllable by segment manager
Profit margin traceable to segment
arrow_forward
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the
year just ended follow.
Outlying
$370,000
54,000
106,000
44,000
Metro
Suburban
$770,000
104,000
276,000
154,000
Service revenue
$970,000
Variable expenses
Controllable fixed expenses
Fixed expenses controllable by others
154,000
356,000
184,000
In addition to the expenses listed above, the company has $55,000 of common fixed expenses. Income-tax expense for the year is
$255,000.
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Inc.
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
Segments
Company
Countywide
Cable Services
Metro
Suburban
Outlying
Segment contribution margin
0 $
0 $
2$
< Prev
Nax
2 of 7
hulu
arrow_forward
The following visualization shows the total sales and profits for each state in the USA where a company sells it goods. Based on principles discussed in the chapter, discuss three different ways the visualization could be changed to simplify its presentation.
arrow_forward
Required information
Exercise 6-4 and Exercise 6-5 (Algo)
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Exercise 6-4 (Algo)
$
Debits
31,900
55,500
732,000
99,500
509,000
53,500
18, 200
41,400
Credits
$ 117,000
35,100
53,500
13,900
579,000
6,200
128,500
628,500
20,700
$1,561,700 $1,561,700
Required:
a. Prepare the closing entries for December 31.
b. Prepare…
arrow_forward
Countywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Sales Revenue $ 1,140,000 $ 940,000 $ 540,000 Variable expenses 188,000 138,000 88,000 Controllable fixed expenses 407,000 327,000 157,000 Fixed expenses controllable by others 218,000 188,000 78,000 In addition to the expenses listed above, the company has $140,000 of common fixed expenses. Income-tax expense for the year is $340,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Incorporated.
arrow_forward
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the
year just ended follow.
Metro
Suburban
Service revenue
Variable expenses
Controllable fixed expenses
Fixed expenses controllable by others
$970,000
154, 000
356,000
184,000
$770,000
104,000
276,000
154,000
Outlying
$370,000
54,000
106,000
44,000
In addition to the expenses listed above, the company has $55,000 of common fixed expenses. Income-tax expense for the year is
$255,000.
ces
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Inc.
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
Segments of Company
Countywide
Cable Services
Outlying
Metro
Suburban
Segment contribution margin
< Prev
2 of 7
Next
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the yearended 31 December, 2021
District Development Facility (DDF) $58,600 CreditSpecial Sanitation Grant from Government $30,260 CreditShare of Common Fund $587,450 CreditProperty Rate (ii) $73,230 CreditFuneral Rate $25,270 CreditSalary Div 1 $266,280 DebitCommission to Revenue Collectors $15,790 DebitPrinting and Publication $66,110 DebitUtility Bills $20,040 DebitConferences $14,580 DebitDonations $80,770 CreditContract Retention $13,970 CreditMarket Tolls $25,550 CreditCourt Fines $109,400 CreditMarriage and Divorce Registration $43,840 CreditTelecommunication Cost $18,830 DebitRepairs and Maintenance $9,720 DebitTown Hall Meetings $64,890 DebitSpecial Audit Fees $27,130 DebitTravel and Transport $54,670 DebitRevenue Receivable $208,570 DebitSalary Div 2 $315,090 DebitAssembly Members Allowance $79,000 DebitConsultancy Cost $4,750 DebitHawkers License $37,150 CreditChop bar License $85,600…
arrow_forward
Analyze the statement of operations for the year 2020 and compare it with the year 2019. Identify and explain 5 of the most important issues.
Shawanaga First Nation
Consolidated Statements of Operations and Accumulated Surplus
Year Ended March 31
2020
2019
Actual
Actual
Revenue
Government funding (Note 16)
$8,669,075
$6,530,279
Sales
5,093,432
4,510,928
Rental and other
350,082
555,231
Interest
44,027
24,225
Loss on disposal of equipment
-673,192
-17,344
Loss from investment in government business enterprise (note5)
-117,480
-56,619
13,365,944
11,546,700
Expenses
Capital
152,153
143,708
Community operations
1,116,702
1,166,556
Economic development
5,152,423
4,527,794
Education
1,223,566
1,107,489
First Nation administration
1,939,337
1,741,586
Health services
2,006,262
1,615,067
Other
358,111
420,012
Social services
300,467
342,587
Total
12,249,021
11,064,799
Annual surplus before prior year
subsidy…
arrow_forward
A
arrow_forward
Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the
year just ended follow.
Service revenue
Variable expenses
Controllable fixed expenses
Fixed expenses controllable by others
Metro
$960, 000
152,000
353, 000
182,000
Suburban
$760,000
102,000
273,000
152,000
Outlying
$360,000
52,000
103,000
42,000
In addition to the expenses listed above, the company has $50,000 of common fixed expenses. Income-tax expense for the year is
$250.000.
Required:
1. Prepare a segmented income statement for Countywide Cable Services, Inc.
SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC.
Segments of Company
Countywide
Cable Services
Outlying
Metro
Suburban
Segment contribution margin
%24
0 $
Profit margin controllable by segment manager
2$
0 $
0 $
0 $
Profit margin traceable to segment
%24
0 $
0 $
MacBook Pro
%23
%
&
3
4
*
7
8
E
R
T
Y
{
D
F
K
V
MOSISO
arrow_forward
Need Help with this Question
arrow_forward
Question ThreeThe following Trial Balance is the financial details of West Municipal Assembly for the yearended 31 December, 2021
District Development Facility (DDF) $58,600 CreditSpecial Sanitation Grant from Government $30,260 CreditShare of Common Fund $587,450 CreditProperty Rate (ii) $73,230 CreditFuneral Rate $25,270 CreditSalary Div 1 $266,280 DebitCommission to Revenue Collectors $15,790 DebitPrinting and Publication $66,110 DebitUtility Bills $20,040 DebitConferences $14,580 DebitDonations $80,770 CreditContract Retention $13,970 CreditMarket Tolls $25,550 CreditCourt Fines $109,400 CreditMarriage and Divorce Registration $43,840 CreditTelecommunication Cost $18,830 DebitRepairs and Maintenance $9,720 DebitTown Hall Meetings $64,890 DebitSpecial Audit Fees $27,130 DebitTravel and Transport $54,670 DebitRevenue Receivable $208,570 DebitSalary Div 2 $315,090 DebitAssembly Members Allowance $79,000 DebitConsultancy Cost $4,750 DebitHawkers License $37,150 CreditChop bar License…
arrow_forward
Question 1 Not complete
Marked out of 7.14
Flag question
Scenario and General Fund budgetary journal entries
The scenario: Croton City maintains four governmental-type funds: a General Fund, a Library Special Revenue Fund, a Capital Projects Fund, and a Debt Service Fund.
Croton City started its calendar year 2019 with the following General Fund balances (all numbers are in thousands of dollars).
Cash
Property taxes receivable
Debits Credits
$1,800
800
Salaries payable
Deferred property tax revenues
Unassigned fund balance
Totals
$700
300
1,600
$2,600
$2,600
Croton has adopted the following budgetary and accounting policies:
• Encumbrance accounting is used only for the acquisition of supplies and for the award of contracts for construction and construction-related activities. Open encumbrances lapse at the end of the year, but are considered in developing the next year's budget.
Because final income tax returns are not required to be filed until April 15 of the year following the end…
arrow_forward
H-9
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at…
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the…
arrow_forward
Solve the problem as soon as possible
arrow_forward
2
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the closing entries for December 31.
Prepare the Statement of Revenues, Expenses, and Changes in Fund…
arrow_forward
None
arrow_forward
K
The governmental funds of the City of Westchester report $576,500 in assets and $219,000 in liabilities. The following are some of the
assets that the government reports.
•
Prepaid items-$8,200
Cash from a bond issuance that must be spent within the school system according to the bond indenture-$111,000
.Supplies-$5,200
• Investments given by a citizen that will be sold soon with the proceeds used to beautify a public park-$36,000
Cash that the assistant director of finance designated for use in upgrading the local roads-$49,750
Cash from a state grant that must be spent to supplement the pay of local kindergarten teachers-$62,750
Cash that the city council (the highest level of decision-making authority in the government) voted to use in renovating a school
gymnasium-$67,250
Required:
On a balance sheet for the governmental funds, what fund balance amounts should the City of Westchester report?
Fund balance-nonspendable
ht
Fund balance-restricted
ences
Fund balance-committed
Fund…
arrow_forward
Required information
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Debits
Adjustments:
$ 29,400
53,000
VILLAGE OF SEASIDE PINES
ENTERPRISE FUND
Reconciliation of Operating Income to
Net Cash Provided by Operating Activities
For the year ended December 31, 2024
722,000
98,000
504,000
51,000
17,700
40,900
19,700
$ 1,535,700
Credits
$ 112,000
32,600
51,000…
arrow_forward
Using the data below for the Ace Guitar Company:
A Region
B Region
Sales
$521,500
$968,500
Cost of goods sold
198,200
368,000
Selling expenses
125,200
232,400
Service department expenses
Purchasing
$250,300
Payroll accounting
166,900
Allocate service department expenses proportional to the sales of each region. Determine the divisional income from operations for the A and B regions. For interim calculations, round percentages to one decimal place.
A Region
$
B Region
$
arrow_forward
TB Problem 21-167 (Algo)
The Murdock Corporation reported the following balance sheet data for 2021 and 2020:
2021
2020
Cash
$
96,245
$
33,155
Available-for-sale debt securities (not cash equivalents)
24,000
102,000
Accounts receivable
97,000
83,550
Inventory
182,000
160,300
Prepaid insurance
3,030
3,700
Land, buildings, and equipment
1,284,000
1,142,000
Accumulated depreciation
(627,000
)
(589,000
)
Total assets
$
1,059,275
$
935,705
Accounts payable
$
91,640
$
165,670
Salaries payable
26,800
33,000
Notes payable (current)
40,300
92,000
Bonds payable
217,000
0
Common stock
300,000
300,000
Retained earnings
383,535
345,035
Total liabilities and shareholders' equity
$
1,059,275
$
935,705
Additional information for 2021:
(1) Sold available-for-sale debt securities costing…
arrow_forward
TB Problem 21-167 (Algo)
The Murdock Corporation reported the following balance sheet data for 2021 and 2020:
2021
2020
Cash
$
96,245
$
33,155
Available-for-sale debt securities (not cash equivalents)
24,000
102,000
Accounts receivable
97,000
83,550
Inventory
182,000
160,300
Prepaid insurance
3,030
3,700
Land, buildings, and equipment
1,284,000
1,142,000
Accumulated depreciation
(627,000
)
(589,000
)
Total assets
$
1,059,275
$
935,705
Accounts payable
$
91,640
$
165,670
Salaries payable
26,800
33,000
Notes payable (current)
40,300
92,000
Bonds payable
217,000
0
Common stock
300,000
300,000
Retained earnings
383,535
345,035
Total liabilities and shareholders' equity
$
1,059,275
$
935,705
Additional information for 2021:
(1) Sold available-for-sale debt securities costing…
arrow_forward
59. Question: In conformity with the revenue test, what is the total revenue of the reportable segments?
CHOICES:
P51,000
P52,000
P71,000
P60,000
arrow_forward
FINA310 IP TEMPLATE FOR STUDENTS
Student name:
Date:
ACTUAL
FORECAST
Current Year
Next Year
Total Revenue
71,879
|Cost of Revenue
(51,125)
Gross Profit
20,754
Operating Expenses:
Selling, General, and Administrative
(14,248)
Research and Development
Special Income/Other Charges
(2,194)
Total Operating Expenses
(16,442)
Operating Income
4,312
Net Interest Income
(666)
edite
Pre-Tax Income
3,646
Provision for Income Tax (19.5%)
(711)
Net Income
2,935
Additionally, Tag-It's CEO has predicted a 12% increase in total
revenue next year. Utilizing the percentage of sales method, prepare
a forecast for next year in the correct section on the Excel
spreadsheet.
1. The total revenue numbers over the past 4 years for Tag-lt
Corporation were as follows (values in millions):
o 73,785
O 69,495
o 75,356
o 71,879
2. Determine whether you think Tag-It can hit the target of a 12%
increase in sales next year.
arrow_forward
Please show work as well, thanks!
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- City of Smithville General Fund Operating statement account balances For year 2023 Estimated Revenues Dr(Cr) Revenues Dr(Cr) Balance Dr(Cr) Acct 3020/4020 Estimated Revenues-Property Taxes $1,877,413 $1,877,578 ($165) Acct 3030/4030 Estimated Revenues-Sales Taxes 1,578,000 1,579,203 (1,203) Acct 3040/4040 Estimated Revenues-Interest and Penalties on Taxes 15,000 12,571 2,429 Acct 3050/4050 Estimated Revenues-Licenses and Permits 500,000 497,960 2,040 Acct 3060/4060 Estimated Revenues-Fines and Forfeits 175,000 173,590 1,410 Acct 3070/4070 Estimated Revenues-Intergovernmental Revenue 789,000 789,000 0 Acct 3080/4080 Estimated Revenues-Charges for Services 659,720 661,253 (1,533) Acct 3090/4090 Estimated Revenues-Miscellaneous Revenues 91,300 91,250 50 Encumberances Dr(Cr) Expenditures Dr(Cr) Appropriations Cr(Dr) Available Balance Cr(Dr) Acct 5020 / 6020 / 7020 Appropriations-General…arrow_forwardSh18 Please help me Solution Thankyou.arrow_forwardr 0 Chesterfield County had the following transactions. a. A budget is passed for all ongoing activities. Revenue is anticipated to be $1,023,250, with approved spending of $611,000 and operating transfers out of $336,000. Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does b. A contract is signed with a construction company to build a new central office building for the government at a cost of $9,000,000. The county previously recorded the budget for this project. c. Bonds are issued for $9,000,000 (face value) to finance construction of the new office building. d. The new building is completed. An invoice for $9,000,000 is received by the county and paid. e. Previously unrestricted cash of $1,600,000 is set aside by county officials to begin paying the bonds issued in (c). f. A portion of the bonds comes due, and $1,600,000 is paid. Of this total, $115,000 represents interest. The interest had not been previously accrued. g.…arrow_forward
- Countywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Service revenue $ 1,150,000 Variable expenses 190,000 $ 950,000 140,000 Controllable fixed expenses Fixed expenses controllable by others 410,000 220,000 330,000 190,000 Outlying $ 550,000 90,000 160,000 80,000 In addition to the expenses listed above, the company has $145,000 of common fixed expenses. Income-tax expense for the year is $345,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Incorporated. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INCORPORATED Segments of Company Countywide Cable Services Metro Suburban Outlying Segment contribution margin Profit margin controllable by segment manager Profit margin traceable to segmentarrow_forwardCountywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Outlying $370,000 54,000 106,000 44,000 Metro Suburban $770,000 104,000 276,000 154,000 Service revenue $970,000 Variable expenses Controllable fixed expenses Fixed expenses controllable by others 154,000 356,000 184,000 In addition to the expenses listed above, the company has $55,000 of common fixed expenses. Income-tax expense for the year is $255,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC. Segments Company Countywide Cable Services Metro Suburban Outlying Segment contribution margin 0 $ 0 $ 2$ < Prev Nax 2 of 7 huluarrow_forwardThe following visualization shows the total sales and profits for each state in the USA where a company sells it goods. Based on principles discussed in the chapter, discuss three different ways the visualization could be changed to simplify its presentation.arrow_forward
- Required information Exercise 6-4 and Exercise 6-5 (Algo) [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Exercise 6-4 (Algo) $ Debits 31,900 55,500 732,000 99,500 509,000 53,500 18, 200 41,400 Credits $ 117,000 35,100 53,500 13,900 579,000 6,200 128,500 628,500 20,700 $1,561,700 $1,561,700 Required: a. Prepare the closing entries for December 31. b. Prepare…arrow_forwardCountywide Cable Services, Incorporated, is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Sales Revenue $ 1,140,000 $ 940,000 $ 540,000 Variable expenses 188,000 138,000 88,000 Controllable fixed expenses 407,000 327,000 157,000 Fixed expenses controllable by others 218,000 188,000 78,000 In addition to the expenses listed above, the company has $140,000 of common fixed expenses. Income-tax expense for the year is $340,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Incorporated.arrow_forwardCountywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Service revenue Variable expenses Controllable fixed expenses Fixed expenses controllable by others $970,000 154, 000 356,000 184,000 $770,000 104,000 276,000 154,000 Outlying $370,000 54,000 106,000 44,000 In addition to the expenses listed above, the company has $55,000 of common fixed expenses. Income-tax expense for the year is $255,000. ces Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. SEGMENTED INCOME STATEMENTS: COUNTYWIDE CABLE SERVICES, INC. Segments of Company Countywide Cable Services Outlying Metro Suburban Segment contribution margin < Prev 2 of 7 Nextarrow_forward
- The following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…arrow_forwardThe following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…arrow_forwardThe following Trial Balance is the financial details of West Municipal Assembly for the yearended 31 December, 2021 District Development Facility (DDF) $58,600 CreditSpecial Sanitation Grant from Government $30,260 CreditShare of Common Fund $587,450 CreditProperty Rate (ii) $73,230 CreditFuneral Rate $25,270 CreditSalary Div 1 $266,280 DebitCommission to Revenue Collectors $15,790 DebitPrinting and Publication $66,110 DebitUtility Bills $20,040 DebitConferences $14,580 DebitDonations $80,770 CreditContract Retention $13,970 CreditMarket Tolls $25,550 CreditCourt Fines $109,400 CreditMarriage and Divorce Registration $43,840 CreditTelecommunication Cost $18,830 DebitRepairs and Maintenance $9,720 DebitTown Hall Meetings $64,890 DebitSpecial Audit Fees $27,130 DebitTravel and Transport $54,670 DebitRevenue Receivable $208,570 DebitSalary Div 2 $315,090 DebitAssembly Members Allowance $79,000 DebitConsultancy Cost $4,750 DebitHawkers License $37,150 CreditChop bar License $85,600…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education