PROBLEM D Given the assumptions below conceming the Speedy Growth Company, construct the income statement, balance sheet and cash inflow-outflow statement for the company for the month of MARCH (you can cither use Excel or fill in the statements on the following page - the entries on the following page should help "guide" you to the correct solutions). ASSUMPTIONS: Initial investment (made on January I when company begins operations) - $900,000 Selling price $125 per unit; COGS = $80 per unit; Fixed costs -$30,000 per month; tax rate - 15% Credit policy net 40 days (assume 70% of sales are on credit and 30% of sales are for cash) - all sales are eventually collected, meaning there is no bad debt. o Since sales in January - 5000 units (sce below), collections of cash sales in January will be (.30)(5000)($125) = $187,500; collections of credit sales will be $0 since the ACP is greater than 30 days. And, accounts receivable on the January B/S will be (.70)(5000)($125) = $437,500 (i.e., all sales to date that have not yet been collected). Inventory policy = 10-day supply o Note that this means inventory at the end of the month will be 10/30 of sales for that month. Thus, given that January sales 5,000 units (see below), January ending inventory will be 1666.67 units; inventory is carried at cost (i.e., at $80 per unit), thus January inventory on the balance sheet = 133,333 - round all values to nearest whole number (thus, round $133,333.33 to $133,333). All bills are paid immediately (this implies that accounts payable and accruals = $0). Dividends $20,000 per month; There are 30 days in every month; All revenues, costs, cash inflows and cash outflows are evenly distributed through the month If additional funds are needed, these will be in the form of debt (i.e., bank loans). The company will borrow money if cash = $0 on the balance sheet. The amount borrowed will be what is necessary to balance the balance sheet with cash = $0. • Monthly Sales: January = 5,000 units, February = 9,000 units, March = 15,000 units Use the statements you created to answer the following questions. Record all answers as a dollar amount rounded to zero (0) decimal places, but do not record a dollar sign or any commas. If your answer is negative (i.c., a loss), put a hyphen before your answer with no space between the- sign and the number. For example, record negative $23,243.83 as -23244. 15. Net income in March= 16. Addition to retained earnings in March = 17. Accounts receivable in March 18. Debt in March 19. Collection of cash sales + collection of credit sales in March- 20. Net cash flow in March =

Entrepreneurial Finance
6th Edition
ISBN:9781337635653
Author:Leach
Publisher:Leach
Chapter5: Evaluating Operating And Financial Performance
Section: Chapter Questions
Problem 5EP
icon
Related questions
Question
100%

Answer question no 20 alone.if answered in 30mins,it would be appreciable!!

the - sign and the number. For example, record negative $23,243.83 as -23244.
PROBLEM D
Given the assumptions below conceming the Speedy Growth Company, construct the income statement, balance
sheet and cash inflow-outflow statement for the company for the month of MARCH (you can either use Excel or
fill in the statements on the following page - the entries on the following page should help "guide" you to the
correct solutions).
ASSUMPTIONS:
Initial investment (made on January I when company begins operations) = $900,000
Selling price = $125 per unit; COGS = $80 per unit; Fixed costs $30,000 per month; tax rate = 15%
Credit policy = net 40 days (assume 70% of sales are on credit and 30% of sales are for cash) - all sales are
eventually collected, meaning there is no bad debt.
o Since sales in January = 5000 units (sce below), collections of cash sales in January will be
(.30)(5000)(S125) - $187,500; collections of credit sales will be $0 since the ACP is greater than
30 days. And, accounts receivable on the January B/S will be (.70)(5000)(S125) = $437,500 (i.e.,
all sales to date that have not yet been collected).
Inventory policy = 10-day supply
o Note that this means inventory at the end of the month will be 10/30 of sales for that month. Thus,
given that January sales = 5,000 units (sce below), January ending inventory will be 1666.67 units;
inventory is carried at cost (i.e., at $80 per unit), thus January inventory on the balance sheet =
133,333 - round all values to nearest whole number (thus, round $133,333.33 to $133,333).
All bills are paid immediately (this implices that accounts payable and accruals= $0).
Dividends = $20,000 per month; There are 30 days in every month; All revenues, costs, cash inflows and
cash outflows are evenly distributed through the month
If additional funds are needed, these will be in the form of debt (i.e., bank loans). The company will borrow
money if cash = $0 on the balance sheet. The amount borrowed will be what is necessary to balance the
balance sheet with cash $0.
Monthly Sales: January = 5,000 units, February = 9,000 units, March = 15,000 units
%3D
Use the statements you created to answer the following questions. Record all answers as a dollar amount rounded to
zero (0) decimal places, but do not record a dollar sign or any commas. If your answer is negative (i.e., a loss), put a
hyphen before your answer with no space between the - sign and the number. For example, record negative
$23,243.83 as -23244.
15. Net income in March =
16. Addition to retained earmings in March =
17. Accounts receivable in March =
18. Debt in March =
19. Collection of cash sales + collection of credit sales in March
20. Net cash flow in March =
Transcribed Image Text:the - sign and the number. For example, record negative $23,243.83 as -23244. PROBLEM D Given the assumptions below conceming the Speedy Growth Company, construct the income statement, balance sheet and cash inflow-outflow statement for the company for the month of MARCH (you can either use Excel or fill in the statements on the following page - the entries on the following page should help "guide" you to the correct solutions). ASSUMPTIONS: Initial investment (made on January I when company begins operations) = $900,000 Selling price = $125 per unit; COGS = $80 per unit; Fixed costs $30,000 per month; tax rate = 15% Credit policy = net 40 days (assume 70% of sales are on credit and 30% of sales are for cash) - all sales are eventually collected, meaning there is no bad debt. o Since sales in January = 5000 units (sce below), collections of cash sales in January will be (.30)(5000)(S125) - $187,500; collections of credit sales will be $0 since the ACP is greater than 30 days. And, accounts receivable on the January B/S will be (.70)(5000)(S125) = $437,500 (i.e., all sales to date that have not yet been collected). Inventory policy = 10-day supply o Note that this means inventory at the end of the month will be 10/30 of sales for that month. Thus, given that January sales = 5,000 units (sce below), January ending inventory will be 1666.67 units; inventory is carried at cost (i.e., at $80 per unit), thus January inventory on the balance sheet = 133,333 - round all values to nearest whole number (thus, round $133,333.33 to $133,333). All bills are paid immediately (this implices that accounts payable and accruals= $0). Dividends = $20,000 per month; There are 30 days in every month; All revenues, costs, cash inflows and cash outflows are evenly distributed through the month If additional funds are needed, these will be in the form of debt (i.e., bank loans). The company will borrow money if cash = $0 on the balance sheet. The amount borrowed will be what is necessary to balance the balance sheet with cash $0. Monthly Sales: January = 5,000 units, February = 9,000 units, March = 15,000 units %3D Use the statements you created to answer the following questions. Record all answers as a dollar amount rounded to zero (0) decimal places, but do not record a dollar sign or any commas. If your answer is negative (i.e., a loss), put a hyphen before your answer with no space between the - sign and the number. For example, record negative $23,243.83 as -23244. 15. Net income in March = 16. Addition to retained earmings in March = 17. Accounts receivable in March = 18. Debt in March = 19. Collection of cash sales + collection of credit sales in March 20. Net cash flow in March =
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Analytical Techniques
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning