Question
In: Finance
Sailboats, Etc is a retail company specializing in sailboats and other sailing related equipment. The table...
Sailboats, Etc is a retail company specializing in sailboats and other sailing related equipment. The table shown here contains financial forecasts as well as current (month 0) working capital levels. During which month is the firm's change in net working capital the greatest? When does it have surplus?
0 1 2 3 4 5 6
Net income 10.42 12.14 15.08 24.72 29.72 17.75
Depreciation 1.93 2.91 3.04 4.07 4.99 3.96
Capital Expenditures 1.02 0.00 0.00 1.05 0.00 0.00
Levels of working Cap.
Accounts Rec. 1.92 2.98 3.96 4.99 7.05 10.04 6.01
Inventory 2.94 1.95 3.91 4.99 5.05 4.01 2.02
Accounts Pay. 1.95 1.95 1.95 1.95 1.95 1.95 1.95
Please if you work out this problem can you do it by hand, so that I may learn the steps in doing this problem. I do not follow Excel that well. Thank You
Solutions
Expert Solution
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
JUST WRITTEN IN EXCEL. NO FORMULAS USED AT ALL. IT IS ALL BASIC MATHS. THANK YOU
CHANGES IN WORKING CAPITAL :
ACCOUNT RECEIVABLE = t(n) - t(n-1) = t(1) - t(0) = 2.98 - 1.92 = 1.06, t(2) -t(1) = 3.96 - 2.98 = 0.98 and so on
same way for inventory and accounts payable
jeff jeffy answered 2 years agoRelated Solutions
W.7- (8) Sailboats Etc. is a retail company specializing in sailboats and other sailing-related equipment. The...
W.7- (8)
Sailboats Etc. is a retail company specializing in sailboats and
other sailing-related equipment. The table shown here, contains
financial forecasts as well as current (month 0) working capital
levels. During which month is the firm's change in net working
capital the greatest? When does it have surplus cash? We calculate
the changes in net working capital for the firm: (Round to two
decimal places.)
($000)
0
1
2
3
4
5
6
Net Income
$10.14
$11.83
$15.08
$25.01...
Summer Breeze Inc. (SBI) is a retail outlet specializing in equipment and apparel for the summer...
Summer Breeze Inc. (SBI) is a retail outlet specializing in
equipment and apparel for the summer months. SBI is trying to
prepare a comprehensive budget for the first quarter of 2018. SBI
has accumulated the following data:
Balance Sheet as of December 31, 2017
(Actual Values)
Assets
Liabilities and Equity
Cash
$ 25,000
Accounts Payable
$ 40,000
Accounts Receivable
75,000
Other Payables
28,200
Inventory
22,000
Common Stock
400,000
Fixed Assets, net
500,000
Retained...
Summer Breeze Inc. (SBI) is a retail outlet specializing in equipment and apparel for the summer...
Summer Breeze Inc. (SBI) is a retail outlet specializing in
equipment and apparel for the summer months. SBI is trying to
prepare a comprehensive budget for the first quarter of 2018. SBI
has accumulated the following data:
Balance Sheet as of December 31, 2017
(Actual Values)
Assets
Liabilities and Equity
Cash
$ 25,000
Accounts Payable
$ 40,000
Accounts Receivable
75,000
Other Payables
28,200
Inventory
22,000
Common Stock
400,000
Fixed Assets, net
500,000
Retained...
Summer Breeze Inc. (SBI) is a retail outlet specializing in equipment and apparel for the summer...
Summer Breeze Inc. (SBI) is a retail outlet specializing in
equipment and apparel for the summer months. SBI is trying to
prepare a comprehensive budget for the first quarter of 2018. SBI
has accumulated the following data:
Balance Sheet as of December 31, 2017
(Actual Values)
Assets
Liabilities and Equity
Cash
$ 25,000
Accounts Payable
$ 40,000
Accounts Receivable
75,000
Other Payables
28,200
Inventory
22,000
Common Stock
400,000
Fixed Assets, net
500,000
Retained...
Aqua Corporation is a retail operation specializing in pool equipment and outdoor furniture. It is very...
Aqua Corporation is a retail operation specializing in pool
equipment and outdoor furniture. It is very interested in merging
with Icterine Corporation, a lamp manufacturer; Aqua is very
profitable and Icterine has large business credits that it has not
been able to utilize.
Aqua proposes to exchange about 40% of its stock and $200,000
for most of Icterine’s assets. The assets not acquired by Aqua will
be distributed to Icterine’s shareholders. Aqua stock will be
distributed to most of Icterine’s...
Summer Breeze Inc. (SBI) is a retail outlet specializing in equipment and apparel for the summer...
Summer Breeze Inc. (SBI) is a retail outlet specializing in
equipment and apparel for the summer months. SBI is trying to
prepare a comprehensive budget for the first quarter of 2018. SBI
has accumulated the following data:
Balance Sheet as of December 31, 2017
(Actual Values)
Assets
Liabilities and Equity
Cash
$ 25,000
Accounts Payable
$ 40,000
Accounts Receivable
75,000
Other Payables
28,200
Inventory
22,000
Common Stock
400,000
Fixed Assets, net
500,000
Retained...
Master Budget Project Summer Breeze Inc. (SBI) is a retail outlet specializing in equipment and apparel...
Master Budget Project
Summer Breeze Inc. (SBI) is a retail outlet specializing in
equipment and apparel for the summer months. SBI is trying to
prepare a comprehensive budget for the first quarter of 2018. SBI
has accumulated the following data:
Balance Sheet as of December 31, 2017
(Actual Values)
Assets
Liabilities and Equity
Cash
$ 25,000
Accounts Payable
$ 40,000
Accounts Receivable
75,000
Other Payables
28,200
Inventory
22,000
Common Stock
400,000
Fixed Assets, net...
Research a company that sells network equipment (like Cisco, Juniper, Netgear, etc). Use Table 2. For...
Research a company that sells network equipment (like
Cisco, Juniper, Netgear, etc). Use Table 2. For each OSI layer,
identify and describe in detail a hardware device best suited for
each layer of the model. Refer back to chapters 2 and 7 for
commonly used network hardware. For each hardware component
selected, include the model number and device specifications.
Choose a company that is significantly affected by COVID-19 such as transportation, retail etc. The company...
Choose a company that is significantly affected by COVID-19 such
as transportation, retail etc. The company must be a constituent of
the S&P/ASX 300 index
Provide a detailed explanation of the impairment testing made by
your company in the year ended 30 June 2019. Your explanation
should include a discussion of i. the asset/s that were subject to
impairment testing; ii. the type of estimations required to record
the impairment; iii. the amount of the impairment write-down, if
any; and...
Is HDTV ownership related to quantity of purchases of other electronics? A Best Buy retail outlet...
Is HDTV ownership related to quantity of purchases of other
electronics? A Best Buy retail outlet collected the following data
for a random sample of its recent customers. At α = 0.10,
is the frequency of in-store purchases independent of the number of
large-screen HDTVs owned (defined as 50 inches or more)?
In-Store Purchases Last Month
HDTVs Owned
None
One
More Than One
Row Total
None
14
15
12
41
One
17
33
30
80
Two or More
19
40...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- In C++ Write a function that took in SIZE and array [size] and counted the number...
- . What are the current issues with managing the supply chain? In general, how can blockchain...
- Define what an array index value is in JAVA. Then, write a JAVA program that passes...
- A buffer contains 1.0 mol of CH3CO2H and 1.0 mol of CH3CO2- diluted with water to...
- - A primary sedimentation basin for a municipal waste water treatment plant treats a flow of...
- Hello I'm currently having an error that says "main is not abstract and does not override...
- Give a direct proof of the following theorem, upon which case you can use it for...
ADVERTISEMENT