Question

SHOW YOUR WORK, DO NOT USE EXCEL Company A spends $100k on inventory in April. It...

SHOW YOUR WORK, DO NOT USE EXCEL

Company A spends $100k on inventory in April. It produces its products and sells to consumers in May for $150k. Payment is received in June. For each month, find the firm’s sales, net income, and changes in NWC.

Homework Answers

Answer #1

Hi,

Here IN May month cost on inventory = $100k

Sales =0

so IN April firm sales = 0

Net Income = Sales - cost

= 0- 100k =-$100k

nwc = current asset - current liability

since $100k spent on inventory hence current asset increased by $100k

but at the same time cash also decreased by $100k so net working remains the same.

HEnce change in NWC = 0

In May.

Sold to customer for $150k

so firm sales = $150k

net income = 150-0 = $150k

inventory reduced by 100k but account receivable increased by 150k

so change in NWC= 150-100 = $50k

IN June

Sales= 0

Net income =0

account receivable moved to cash

so change in NWC =0

Thanks

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Please show work in Excel and state the other company (competitor) Calculate the CCC for your...
Please show work in Excel and state the other company (competitor) Calculate the CCC for your selected company and for one of your company's competitors. (Note: You can find a list of competitors to choose from in the "Competitors" tab within Yahoo! Finance.) Use the most recent fiscal year financial statements to calculate the different components of the CCC and its overall value. The components of the CCC are: Days Payable Outstanding (DPO) Days Sales Outstanding (DSO) Days Inventory Outstanding...
13. If the cost of the beginning work in process inventory is $57,000, direct materials cost...
13. If the cost of the beginning work in process inventory is $57,000, direct materials cost is $347,000, direct labor cost is $213,000, and overhead cost is $316,000, and the ending work in process inventory is $52,000, calculate the cost of goods manufactured: 13B. On January 4, Year 1, Barber Company purchased 6,400 shares of Convell Company for $73,500 plus a broker's fee of $1,280. Convell Company has a total of 32,000 shares of common stock outstanding and it is...
Rafael Ron trades as Goal Company. He buys and sells professional soccer balls. For the April...
Rafael Ron trades as Goal Company. He buys and sells professional soccer balls. For the April of 2017, the following details of his business are available: Opening inventory of balls (on 1st April 2017): 150 pieces at total cost of £1,200 Purchased in April: 180 pieces of balls at £7.5 each During April he sold 190 pieces for £17 each (£3,230 in total) Closing stock is valued at £7.5 per piece Rent for the storehouse is paid in advance: the...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 60,000 Accounts receivable 30,000 Inventory 43,900 Buildings and equipment, net of depreciation 131,000 Total assets $ 264,900 Liabilities and Stockholders’ Equity Accounts payable $ 72,000 Common stock 70,000 Retained earnings 122,900 Total liabilities and stockholders’ equity $ 264,900 Budgeted Income Statements April May June Sales $ 113,000 $...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via...
Citrus Girl Company (CGC) purchases quality citrus produce from local growers and sells the produce via the Internet across the United States. To keep costs down, CGC maintains a warehouse, but no showroom or retail sales outlets. CGC has the following information for the second quarter of the year: Expected monthly sales for April, May, June, and July are $250,000, $220,000, $340,000, and $120,000, respectively. Cost of goods sold is 25 percent of expected sales. CGC’s desired ending inventory is...
A company Motorsports sells a new sports car. Here are the records of shipments and sales...
A company Motorsports sells a new sports car. Here are the records of shipments and sales for the six months of this year. The BOM inventory is the number of cars on hand just before the first business day of the month. Sales is the number of cars sold during the month, including new backorders. Received is the number of cars received on the first business day of the month. Company inventory and sales records Month BOM inventory Sales Received...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will...
Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It began negotiating for a one-month bank loan of $500,000 starting May 1. The bank would charge interest at the rate of 1.00 percent per month and require the company to repay interest and principal on May 31. In considering the loan, the bank requested a projected income statement and cash budget for May. The following information...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file of what Excel functions you used and when you used them, and how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and...