BURROW-A
XLS
keyboard_arrow_up
School
University of California, Los Angeles *
*We aren’t endorsed by this school
Course
231E
Subject
Finance
Date
Nov 24, 2024
Type
XLS
Pages
7
Uploaded by leedevin
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 1
EXHIBIT Ia
BURROWS, INC
Projected Statement of Income for the Six Years Ending
January 31st, 1978 (000)
1972-1977
Annual
Sales
$Sales
Opening
Square Feet
1/31/1973
1/31/1974
1/31/1975
1/31/1976
1/31/1977
1/31/1978
Increase
Sq. Ft. Gross Space
Store Location
Date
Gross
Selling
(1972)
(1973)
(1974)
(1975)
(1976)
(1977)
(%/yr.)
(1972)
(1977)
Downtown
9/18/1971
26,463
9,500
1300
1360
1000
1000
1000
1000
6
49
38
Eastwood Mall
2/1/1971
4,878
3,652
100
175
175
200
225
250
30
21
51
Great Lakes Mall
4,454
3,415
250
273
350
400
450
500
20
56
112
Subway Downtown
5/1/1973
1,596
1,422
110
112
135
145
150
0
7
69
Southland
5,000
4,100
0
146
200
250
300
350
33
70
Severence Center
4,304
2,594
530
567
600
650
700
750
8
123
174
Southgate Center
4,550
3,140
470
494
530
560
590
620
5
103
136
Warren Road
4,000
2,289
210
217
240
255
270
285
7
53
71
Webster Company (contract sales)
10,000
0
125
149
175
200
225
250
20
13
25
Willowich
4,200
2,702
185
196
215
230
245
260
19
44
62
Shaker Heights
3,978
2,098
230
239
260
275
290
300
6
58
75
Summit Mall
9/1/1973
4,500
3,700
0
130
170
200
230
260
23
58
Shaker Square
5,474
4,085
360
377
400
420
440
460
5
66
84
Chapel Hill
4,500
3,700
0
0
150
200
250
300
25
67
Westgate Center
3,600
2,567
400
443
450
475
500
525
6
111
146
Farmstown Center
4,500
3,096
330
348
390
420
450
480
9
73
107
Great Northern Center
2,750
2,388
220
230
250
265
280
295
7
80
107
Eastwood Mall-Kiosk
10/4/1971
528
528
97
108
120
130
140
150
11
184
284
Farms-Kiosk
2/1/1972
1,000
1,000
160
163
200
220
240
260
12
160
260
Southern Park
8/72
4,026
3,023
130
240
230
260
290
320
9
32
79
Brooklyn Heights Warehouse
11/73
40,000
4,000
0
0
650
800
1000
1200
30
Rolling Acres
10/74
4,500
3,700
0
0
100
140
200
230
51
Midway Mall
5/75
4,500
3,700
0
0
0
150
200
250
56
Belden Village
8/75
4,500
3,700
0
0
0
100
200
250
56
Strongsville
5/76
4,500
3,700
0
0
0
0
150
200
44
9th & Euclid
8/76
4,500
3,700
0
0
0
0
100
150
33
Eastland
5/77
4,500
3,700
0
0
0
0
0
150
33
Westland
8/77
4,500
3,700
0
0
0
0
0
120
27
Total Sales
175,801
88,899
5,207
5,967
6,990
7,945
9,115
10,165
20
30
58
Cost of Goods Sold
2,977
3,341
3,914
4,449
5,104
5,692
Gross Margin
2,230
2,626
3,076
3,496
4,011
4,473
Expenses
1,950
2,296
2,666
2,946
3,231
3,543
Income Before Income Taxes
280
330
410
550
780
930
Income Taxes
140
165
205
275
390
465
Net Income
$140
$165
$205
$275
$390
$465
(%Sales)
2.7%
2.8%
2.9%
3.5%
4.3%
4.6%
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 2
EXHIBIT Ib
BURROWS, INC
Projected Statement of Income for Twelve Months Ending January 31, 1974 (000)
Store Location
F
M
A
M
J
J
A
S
O
N
D
J
Total
Downtown
$108
$128
$112
$106
$123
$96
$82
$120
$100
$105
$180
$100
$1,360
Eastwood Mall
12
15
15
10
14
12
11
16
11
14
35
10
175
Great Lakes Mall
16
20
17
15
20
15
16
25
16
23
70
20
273
Subway Downtown
9
10
8
8
10
7
7
9
8
11
15
10
112
Southland
0
0
0
10
14
13
12
19
13
15
35
15
146
Severence Center
36
42
37
34
50
33
35
60
40
45
110
45
567
Southgate Center
35
40
32
30
40
30
32
50
33
37
95
40
494
Warren Road
15
18
14
13
16
12
14
22
17
18
38
20
217
Webster Company (contract sales)
5
25
8
10
10
30
7
15
7
15
10
7
149
Willowich
14
17
15
12
16
13
12
19
13
15
35
15
196
Shaker Heights
17
20
17
16
21
14
15
25
18
18
36
22
239
Summit Mall
0
0
0
0
0
0
0
18
12
20
60
20
130
Shaker Square
23
27
21
25
35
20
24
37
25
33
80
27
377
Chapel Hill
0
0
0
0
0
0
0
0
0
0
0
0
0
Westgate Center
27
34
28
25
35
26
28
45
30
35
95
35
443
Farmstown Center
23
27
22
20
25
20
19
36
22
29
75
30
348
Great Northern Center
15
18
15
14
17
14
13
25
15
19
45
20
230
Eastwood Mall-Kiosk
9
10
6
9
10
5
6
8
7
9
23
6
108
Farms-Kiosk
14
15
9
12
15
8
9
12
10
13
37
9
163
Southern Park
15
17
15
14
17
14
18
20
14
22
60
14
240
Total Sales
393
483
391
383
488
382
360
581
411
496
1,134
465
5,967
Cost of Goods Sold
220
270
219
214
273
214
202
325
230
278
636
260
3,341
Gross Margin
173
213
172
169
215
168
158
256
181
218
498
205
2,626
Expenses
170
195
170
170
190
170
172
227
175
190
277
190
2,296
Income Before Income Taxes
3
18
2
(1)
25
(2)
(14)
29
6
28
221
15
330
Income Taxes
1
9
1
0
13
(1)
(7)
15
3
14
110
7
165
Net Income (loss)
2
9
1
(1)
12
(1)
(7)
14
3
14
111
8
165
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 3
EXHIBIT II
BURROWS, INC.
Projected Balance Sheet for the Twelve Months Ending January 31, 1974
and the Five Years Ending January 31, 1978 (000)
2/3/1973
3/3/1973
3/31/1973
4/28/1973
5/26/1973
6/23/1973
7/28/1973
8/25/1973
9/22/1973
###
###
###
1/31/1974
1/31/1975
Cash
$14
$314
$444
$462
$418
$450
$434
$410
$401
$371
$392
$841
$678
$819
Accounts Receivable
3
3
2
1
0
0
0
0
0
0
0
0
0
0
Inventory
1,363
1,295
1,200
1,200
1,255
1,200
1,310
1,310
1,310
1,310
1,475
1,365
1,310
1,540
1,380
1,612
1,646
1,663
1,673
1,650
1,744
1,720
1,711
1,681
1,867
2,206
1,988
2,359
Fixtures and Equipment
665
665
665
665
720
735
745
772
817
860
870
870
870
1,044
Less Res. for Depreciation
(470)
(475)
(480)
(485)
(490)
(496)
(502)
(508)
(514)
(521)
(528)
(535)
(542)
(629)
Leasehold Improvements
320
320
320
320
320
320
320
320
320
320
320
320
320
320
Less Res. for Depreciation
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
(250)
Lease Valuation
50
50
50
50
50
50
50
50
50
50
50
50
50
50
Less Res. for Depreciation
0
(1)
(2)
(2)
(3)
(4)
(4)
(5)
(6)
(6)
(7)
(8)
(8)
(16)
Fixed Assets, net
315
309
303
298
347
355
359
379
417
453
455
447
440
519
Other Assets
30
30
30
30
30
30
40
40
40
40
40
40
40
50
$1,725
$1,951
$1,979
$1,991
$2,050
$2,035
$2,143
$2,139
$2,168
$2,174
$2,362
$2,693
$2,468
$2,928
Accounts Payable
$36
$250
$250
$250
$300
$250
$350
$350
$350
$350
$500
$600
$350
$650
Accured Liabilities
131
140
150
160
170
180
190
200
200
200
210
220
230
300
Income Taxes Payable
0
1
10
11
11
24
23
16
31
34
48
158
165
50
167
391
410
421
481
454
563
566
581
584
758
978
745
1,000
Senior Subordinated Note
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,167
1,391
1,410
1,421
1,481
1,454
1,563
1,566
1,581
1,584
1,758
1,978
1,745
2,000
Preferred Stock
248
248
248
248
248
248
248
248
248
248
248
248
248
248
Common Stock
13
13
13
13
13
13
13
13
13
13
13
13
13
13
Paid-in Surplus
297
297
297
297
297
297
297
297
297
297
297
297
297
297
Retained Earnings
0
2
11
12
11
23
22
15
29
32
46
157
165
370
558
560
569
570
569
581
580
573
587
590
604
715
723
928
$1,725
$1,951
$1,979
$1,991
$2,050
$2,035
$2,143
$2,139
$2,168
$2,174
$2,362
$2,693
$2,468
$2,928
Current Ratio
8.3
4.1
4.0
4.0
3.5
3.6
3.1
3.0
2.9
2.9
2.5
2.3
2.7
2.4
Working Capital
$1,213
$1,221
$1,236
$1,242
$1,192
$1,196
$1,181
$1,154
$1,130
$1,097
$1,109
$1,228
$1,243
$1,359
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
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 4
EXHIBIT III
BURROWS, INC
Projected Statement of Cash Flow for the Twelve Months Ending January 31, 1974
and the Five Years Ended January 31, 1978 (000)
1973
Y
F
M
A
M
J
J
A
S
O
N
D
J
1/31/1974
1/31/1975
Source
Net Income
$2
$9
$1
($1)
$12
($1)
($7)
$14
$3
$14
$111
$8
$165
$205
Depreciation and Amortization
6
6
5
6
7
6
7
7
7
8
8
7
80
95
Cash Flow from Operations
8
15
6
5
19
5
0
21
10
22
119
15
245
300
Decrease in Inventory
68
95
0
0
55
0
0
0
0
0
110
55
383
0
Increase in Current Liabilities
224
19
11
60
0
109
3
15
3
174
220
0
578
255
Decrease in Accounts Receivable
0
1
1
1
0
0
0
0
0
0
0
0
3
0
Total Sources
300
130
18
66
74
114
3
36
13
196
449
70
1,209
555
Use
Capital Expenditures
0
0
0
55
15
10
27
45
43
10
0
0
205
174
Increase in Inventory
0
0
0
55
0
110
0
0
0
165
0
0
330
230
Decrease in Current Liabilities
0
0
0
0
27
0
0
0
0
0
0
233
0
0
Increase in Other Assets
0
0
0
0
0
10
0
0
0
0
0
0
10
10
Increase in Accounts Receivable
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Uses
0
0
0
110
42
130
27
45
43
175
0
233
545
414
Cash Increase (decrease)
300
130
18
(44)
32
(16)
(24)
(9)
(30)
21
449
(163)
664
141
Cash Balance, End of Month/year
314
444
462
418
450
434
410
401
371
392
841
678
678
819
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 5
EXHIBIT VII
BURROWS, INC
Capital Expenditures Forecast (000$)
1973
1974
1975
1976
1977
Warehouse
October
40
Remodeling
Store 0
June
15
5
August
27
6
November
10
27
15
June
27
7
October
3
14
May
10
10
New Fixtures
4
May
45
11
September
45
13
May
50
21
October
50
22
May
50
23
August
50
24
May
50
25
August
50
26
May
50
27
August
50
Contingency
10
10
10
10
10
Total
205
174
110
110
110
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 6
1/31/1976
1/31/1977
1/31/1978
$1,162
$1,578
$2,036
0
100
200
1,683
1,800
2,000
2,845
3,478
4,236
1,154
1,264
1,374
(733)
(859)
(996)
320
320
320
(250)
(250)
(250)
50
50
50
(24)
(32)
(40)
517
493
458
60
70
80
$3,422
$4,041
$4,774
$750
$850
$1,000
400
500
600
69
98
116
1,219
1,448
1,716
1,000
1,000
1,000
2,219
2,448
2,716
248
248
248
13
13
13
297
297
297
645
1,035
1,500
1,203
1,593
2,058
$3,422
$4,041
$4,774
2.3
2.4
2.5
$1,626
$2,030
$2,520
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
9bf4e61c638cfa4cb4d26091fca5d6f6b651a83c.XLS
Page 7
Years Ending
1/31/1976
1/31/1977
1/31/1978
$275
$390
$465
112
134
145
387
524
610
0
0
0
219
229
268
0
0
0
606
753
878
110
110
110
143
117
200
0
0
0
10
10
10
0
100
100
263
337
420
343
416
458
1,162
1,578
2,036
Related Documents
Related Questions
Accounting 12
arrow_forward
Year 1 Year 2 YR 1 YR2Sales (S) $ 614,405.00 $ 600,343.00 Cost of Good Sold (COGS) $ 385,101.00 $ 473,396.00 Gross Profit (GP) $ 229,304.00 $ 226,947.00 Calculate the following: (round to nearest percent) Answer Answer(a) Mark-up percent for year 1 (b) Mark-up percent for year 2 (c) Gross Profit for year 1 (d) Gross Profit for year 2
arrow_forward
bh.3
arrow_forward
20.1 A business has compiled the following information for the year ended 31 October 20X2:
38 mins
$
386,200
989,000
422,700
Opening inventory
Purchases
Closing inventory
The gross profit as a percentage of sales is always 40%
Based on these figures, what is the sales revenue for the year?
$952,500
$1,333,500
$1,587,500
A
C
$1.524.000
arrow_forward
Year
0
1
2
3
4
Earning and FCF Forecast ($ million)
Sales
433
468
516
547
574.3
Growth Versus Prior Year
0.081
0.103
0.06
0.05
Cost of Goods Sold
-313.56
-345.72
-366.49
-384.78
Gross Profit
154.44
170.28
180.51
189.52
Selling, General, and Administrative
-93.6
-103.2
-109.4
-114.86
Depreciation
-7
-7.5
-9
-9.5
EBIT
53.84
59.58
62.11
65.16
Less: Income Tax at 25%
-13.46
-14.9
-15.53
-16.29
Plus: Depreciation
7
7.5
9
9.5
Less: Capital Expenditures
-7.7
-10
-9.9
-10.4
Less: Increase in NWC
-6.3
-8.64
-5.58
-4.91
Free Cash Flow
33.38
33.55
40.1
43.055
Sora Industries has 61 million outstanding shares, $122 million in debt, $53 million in cash, and the following projected free cash flow for the next four years:
.
a. Suppose Sora's revenue and free cash flow are expected to grow at a 4.2% rate beyond year four. If Sora's weighted average cost of capital is 12.0%, what is the value of Sora stock based on this…
arrow_forward
Current Year
Preceding Year
Sales
$9,700,000
$7,175,000
Beginning inventories
420,000
400,000
Cost of goods sold
5,820,000
4,305,000
Ending inventories
550,000
420,000
a. (1.) Determine for each year the inventory turnover. Round answers to one decimal place.
Current year
?
Preceding year
?
(2). Determine for each year the number of days' sales in inventory. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers to one decimal place.
Current year
?
Preceding year
?
b. What conclusions can be drawn from these data concerning the inventories? (sales volume increased faster than the inventory, resultung in an improving inventory position/inventory increased faster than sales colume, resulting in a deteriorating inventroy position/ no conclusion about the inventory position can be drawn from these data)
arrow_forward
Do fast of this question answer general Accounting
arrow_forward
C. Ksh 1,657,530 D. Ksh 2,499,000 The sales data (in units) of book store has been extracted for the three terms over 3 years
as follows; \table[[, Term-, 1 Term-, 2 Term-], [2020, 4500, 3,000, 1,200], [2021, 6,000, 4, 200, 2, 400], [2022, 7, 800, 5, 400, 3, 600]]
Required: Using multiplicative index, forecast sales for term - III (to the nearest 100) of the year 2023 given an annual sales
forecast of 18,000 A. 3, 100 units B. 3,500 units C. 3,300 units D. 3,400 units
arrow_forward
Required information
For Year Ended December 31
Sales
Cost of goods sold
Other operating expenses
Current Year
$ 411, 225
209,550
12, 100
9,525
$ 673,500
642, 400
$31,100
$ 1.90
:. -. - == .......
9 US
Sa
M
arrow_forward
34
arrow_forward
Question 7 of 8
>
-/ 30
Oak Ridge Corporation has accounts receivable of $95,500 at March 31, 2022. An analysis of the accounts shows these amounts.
Balance, March 31
Month of Sale
2022
2021
March (current)
$66,300
$76,200
February (1 - 30 days past due)
12,000
8,800
December and January (31 - 90 days past due)
9,300
2,700
(over 90 days past due)
7,900
1,200
$95,500
$88,900
Credit terms are n/30. At March 31, 2022, there is an unadjusted $2,200 credit balance in Allowance for Doubtful Accounts. The
company uses the percentage of receivables by age category for estimating uncollectible accounts Oak Ridge's estimates of bad debts
are as shown below.
Estimated Percentage
Age of Accounts
Uncollectible
Current
2%
1-30 days past due
5%
31-90 days past due
30%
Over 90 days past due
50%
Prepare an aging schedule to determine the total estimated uncollectibles accounts at March 31, 2022.
III
arrow_forward
QUESTION & 6
The following are estimated the estimated sales of a company for eight month
Navember 30.2020
Escimated Sales (Units)
Manth
12,000
April
13,000
May
9,000
June
8,000
July
10,000
August
September
12,000
October
14,000
November
12,000
As a matter of policy, the company maintains the closing balance of finished goods and raw
materials as follows
Inventory Items
Finished goods
Ending Balance
-50% of estimated sales of next month
Raw materials
--Estimated consumption for next month
Every unit of production requires 2 kgs of raw materials costing Br, 5 per kg
Prepare: Production budget
company for the half year ending September 30,2020
(units) and raw material budget in (units and cost) of the
QUESTION #-7
Financial ratios are the symptoms like the blood pressure, the pulse or the temperature of an
individual. Explain. also name and explain in brief the common types of ratios used by business
companies.
arrow_forward
Assume the following sales data for a company:
Year 2
$562,500
Year 1
$450,000
What is the percentage increase in sales from Year 1 to Year 2 (to the nearest whole percent)?
O a. 20%
O b. 125%
О с. 25%
O d. 80%
arrow_forward
Hi expart Provide answer the general accounting question
arrow_forward
3 Quarter
e Cash
B
A
SoGood Candy Company is evaluating its quarterly working capital needs. Using the information below,
calcuate the working capital, permanent working capital, and temporary working capital needs for the
company.
Accounts Receivable
Inventory
Accounts Payable
Working capital
Permanent W/C
Temporary W/C
1
708
450
650
900
1
2
3 Annual Percentage Rate(APR)
4 Effective Annual Rate (EAR)
2
890
750
550
850
3
670
1200
700
1000
4
1250
800
400
1145
To meet the needs of temporary working capital, SoGood Candy Company has decided to issue
commercial paper which will mature in 8 months. The commercial paper was issued for 1.6 millin and
Othey received 1.5 million. What is the effective annual rate that they will pay for this loan?
arrow_forward
Problem 13-02A (Video)
The comparative statements of Cullumber Company are presented here:
Cullumber CompanyIncome StatementsFor the Years Ended December 31
2020
2019
Net sales
$1,891,640
$1,751,600
Cost of goods sold
1,059,640
1,007,100
Gross profit
832,000
744,500
Selling and administrative expenses
501,100
480,100
Income from operations
330,900
264,400
Other expenses and losses
Interest expense
23,700
21,700
Income before income taxes
307,200
242,700
Income tax expense
93,700
74,700
Net income
$213,500
$168,000
Cullumber CompanyBalance SheetsDecember 31
Assets
2020
2019
Current assets
Cash
$60,100
$64,200
Debt investments (short-term)
74,000
50,000
Accounts receivable
118,900
103,900
Inventory
127,700
117,200
Total current assets
380,700
335,300
Plant assets (net)…
arrow_forward
B ch01 (Fall 2021
w https://education.wiley.
B Present Value Tables (1.
Final Exam (Fall 2020)
- Final Exam (Fall 2020)
-/6
Question 24 of 50
View Policies
Current Attempt in Progress
Sheridan Manufacturing Company expects the following sales in January, February, and March:
Cash
Credit
Sales
Sales
$50900
$250500
January
February
$45900
$240500
March
$85000
$325000
The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month
after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from
customers in March?
O $352150
O $364675
O $410000
O $279675
Save for Later
Attempts: 0 of 1 used
Submit Answer
MacBook Air
esc
888
FT
F2
F3
F4
F5
F6
F7
F8
@
#
2$
4
&
*
6.
7
8.
Q
W
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
- Accounting 12arrow_forwardYear 1 Year 2 YR 1 YR2Sales (S) $ 614,405.00 $ 600,343.00 Cost of Good Sold (COGS) $ 385,101.00 $ 473,396.00 Gross Profit (GP) $ 229,304.00 $ 226,947.00 Calculate the following: (round to nearest percent) Answer Answer(a) Mark-up percent for year 1 (b) Mark-up percent for year 2 (c) Gross Profit for year 1 (d) Gross Profit for year 2arrow_forwardbh.3arrow_forward
- 20.1 A business has compiled the following information for the year ended 31 October 20X2: 38 mins $ 386,200 989,000 422,700 Opening inventory Purchases Closing inventory The gross profit as a percentage of sales is always 40% Based on these figures, what is the sales revenue for the year? $952,500 $1,333,500 $1,587,500 A C $1.524.000arrow_forwardYear 0 1 2 3 4 Earning and FCF Forecast ($ million) Sales 433 468 516 547 574.3 Growth Versus Prior Year 0.081 0.103 0.06 0.05 Cost of Goods Sold -313.56 -345.72 -366.49 -384.78 Gross Profit 154.44 170.28 180.51 189.52 Selling, General, and Administrative -93.6 -103.2 -109.4 -114.86 Depreciation -7 -7.5 -9 -9.5 EBIT 53.84 59.58 62.11 65.16 Less: Income Tax at 25% -13.46 -14.9 -15.53 -16.29 Plus: Depreciation 7 7.5 9 9.5 Less: Capital Expenditures -7.7 -10 -9.9 -10.4 Less: Increase in NWC -6.3 -8.64 -5.58 -4.91 Free Cash Flow 33.38 33.55 40.1 43.055 Sora Industries has 61 million outstanding shares, $122 million in debt, $53 million in cash, and the following projected free cash flow for the next four years: . a. Suppose Sora's revenue and free cash flow are expected to grow at a 4.2% rate beyond year four. If Sora's weighted average cost of capital is 12.0%, what is the value of Sora stock based on this…arrow_forwardCurrent Year Preceding Year Sales $9,700,000 $7,175,000 Beginning inventories 420,000 400,000 Cost of goods sold 5,820,000 4,305,000 Ending inventories 550,000 420,000 a. (1.) Determine for each year the inventory turnover. Round answers to one decimal place. Current year ? Preceding year ? (2). Determine for each year the number of days' sales in inventory. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers to one decimal place. Current year ? Preceding year ? b. What conclusions can be drawn from these data concerning the inventories? (sales volume increased faster than the inventory, resultung in an improving inventory position/inventory increased faster than sales colume, resulting in a deteriorating inventroy position/ no conclusion about the inventory position can be drawn from these data)arrow_forward
- Do fast of this question answer general Accountingarrow_forwardC. Ksh 1,657,530 D. Ksh 2,499,000 The sales data (in units) of book store has been extracted for the three terms over 3 years as follows; \table[[, Term-, 1 Term-, 2 Term-], [2020, 4500, 3,000, 1,200], [2021, 6,000, 4, 200, 2, 400], [2022, 7, 800, 5, 400, 3, 600]] Required: Using multiplicative index, forecast sales for term - III (to the nearest 100) of the year 2023 given an annual sales forecast of 18,000 A. 3, 100 units B. 3,500 units C. 3,300 units D. 3,400 unitsarrow_forwardRequired information For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 411, 225 209,550 12, 100 9,525 $ 673,500 642, 400 $31,100 $ 1.90 :. -. - == ....... 9 US Sa Marrow_forward
- 34arrow_forwardQuestion 7 of 8 > -/ 30 Oak Ridge Corporation has accounts receivable of $95,500 at March 31, 2022. An analysis of the accounts shows these amounts. Balance, March 31 Month of Sale 2022 2021 March (current) $66,300 $76,200 February (1 - 30 days past due) 12,000 8,800 December and January (31 - 90 days past due) 9,300 2,700 (over 90 days past due) 7,900 1,200 $95,500 $88,900 Credit terms are n/30. At March 31, 2022, there is an unadjusted $2,200 credit balance in Allowance for Doubtful Accounts. The company uses the percentage of receivables by age category for estimating uncollectible accounts Oak Ridge's estimates of bad debts are as shown below. Estimated Percentage Age of Accounts Uncollectible Current 2% 1-30 days past due 5% 31-90 days past due 30% Over 90 days past due 50% Prepare an aging schedule to determine the total estimated uncollectibles accounts at March 31, 2022. IIIarrow_forwardQUESTION & 6 The following are estimated the estimated sales of a company for eight month Navember 30.2020 Escimated Sales (Units) Manth 12,000 April 13,000 May 9,000 June 8,000 July 10,000 August September 12,000 October 14,000 November 12,000 As a matter of policy, the company maintains the closing balance of finished goods and raw materials as follows Inventory Items Finished goods Ending Balance -50% of estimated sales of next month Raw materials --Estimated consumption for next month Every unit of production requires 2 kgs of raw materials costing Br, 5 per kg Prepare: Production budget company for the half year ending September 30,2020 (units) and raw material budget in (units and cost) of the QUESTION #-7 Financial ratios are the symptoms like the blood pressure, the pulse or the temperature of an individual. Explain. also name and explain in brief the common types of ratios used by business companies.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