| Item | Prior year | Current year |
| Accounts payable | 8,182.00 | 7,934.00 |
| Accounts receivable | 6,069.00 | 6,515.00 |
| Accruals | 1,006.00 | 1,348.00 |
| Cash | ??? | ??? |
| Common Stock | 11,399.00 | 11,474.00 |
| COGS | 12,747.00 | 18,143.00 |
| Current portion long-term debt | 4,958.00 | 4,954.00 |
| Depreciation expense | 2,500 | 2,830.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,233.00 | 4,808.00 |
| Long-term debt | 14,999.00 | 13,878.00 |
| Net fixed assets | 50,074.00 | 54,846.00 |
| Notes payable | 4,341.00 | 9,877.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,378.00 | 29,936.00 |
| Sales | 35,119 | 47,697.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's cash flow from financing?
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,182.00 | 7,934.00 |
| Accounts receivable | 6,069.00 | 6,515.00 |
| Accruals | 1,006.00 | 1,348.00 |
| Cash | ??? | ??? |
| Common Stock | 11,399.00 | 11,474.00 |
| COGS | 12,747.00 | 18,143.00 |
| Current portion long-term debt | 4,958.00 | 4,954.00 |
| Depreciation expense | 2,500 | 2,830.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,233.00 | 4,808.00 |
| Long-term debt | 14,999.00 | 13,878.00 |
| Net fixed assets | 50,074.00 | 54,846.00 |
| Notes payable | 4,341.00 | 9,877.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,378.00 | 29,936.00 |
| Sales | 35,119 | 47,697.00 |
| Taxes | 2,084 | 2,775 |
What is the firm's total change in cash from the prior year to the current year?
In: Finance
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
178,480.00 |
|
Depreciation expense |
21,600 |
23,731.00 |
|
Interest expense |
16,200 |
16,751.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
137,821.00 |
|
Net fixed assets |
376,128.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
65,598.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
335,829.00 |
|
Taxes |
9,900 |
19,235.00 |
What is the current year's cash balance? Round to 0 decimal places
In: Finance
| Category | Prior Year | Current Year |
| Accounts payable | 3,163.00 | 5,995.00 |
| Accounts receivable | 6,848.00 | 8,905.00 |
| Accruals | 5,712.00 | 6,134.00 |
| Additional paid in capital | 20,329.00 | 13,508.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,048.00 | 18,479.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 998.00 | 1,017.00 |
| Interest expense | 1,283.00 | 1,152.00 |
| Inventories | 3,059.00 | 6,713.00 |
| Long-term debt | 16,606.00 | 22,146.00 |
| Net fixed assets | 75,301.00 | 74,269.00 |
| Notes payable | 4,048.00 | 6,512.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,591.00 | 34,308.00 |
| Sales | 46,360 | 45,170.00 |
| Taxes | 350 | 920 |
What is the firm's cash flow from financing?
Round to 0 decimal places
In: Finance
| Chapter 9: Applying Excel | |||||||
| Data | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | 40,000 | 60,000 | 100,000 | 50,000 | 70,000 | 80,000 | |
| • Selling price per unit | $8 | per unit | |||||
| • Accounts receivable, beginning balance | $65,000 | ||||||
| • Sales collected in the quarter sales are made | 75% | ||||||
| • Sales collected in the quarter after sales are made | 25% | ||||||
| • Desired ending finished goods inventory is | 30% | of the budgeted unit sales of the next quarter | |||||
| • Finished goods inventory, beginning | 12,000 | units | |||||
| • Raw materials required to produce one unit | 5 | pounds | |||||
| • Desired ending inventory of raw materials is | 10% | of the next quarter's production needs | |||||
| • Raw materials inventory, beginning | 23,000 | pounds | |||||
| • Raw material costs | $0.80 | per pound | |||||
| • Raw materials purchases are paid | 60% | in the quarter the purchases are made | |||||
| and | 40% | in the quarter following purchase | |||||
| • Accounts payable for raw materials, beginning balance | $81,500 | ||||||
| Enter a formula into each of the cells marked with a ? below | |||||||
| Review Problem: Budget Schedules | |||||||
| Construct the sales budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | 1 | 2 | ||
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | |
| Selling price per unit | ? | ? | ? | ? | ? | ? | |
| Total sales | ? | ? | ? | ? | ? | ? | |
| Construct the schedule of expected cash collections | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts receivable, beginning balance | ? | ? | |||||
| First-quarter sales | ? | ? | ? | ||||
| Second-quarter sales | ? | ? | ? | ||||
| Third-quarter sales | ? | ? | ? | ||||
| Fourth-quarter sales | ? | ? | |||||
| Total cash collections | ? | ? | ? | ? | ? | ||
| Construct the production budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | 2 | |
| Budgeted unit sales | ? | ? | ? | ? | ? | ? | ? |
| Add desired finished goods inventory | ? | ? | ? | ? | ? | ? | |
| Total needs | ? | ? | ? | ? | ? | ? | |
| Less beginning inventory | ? | ? | ? | ? | ? | ? | |
| Required production | ? | ? | ? | ? | ? | ? | |
| Construct the raw materials purchases budget | Year 2 Quarter | Year 3 Quarter | |||||
| 1 | 2 | 3 | 4 | Year | 1 | ||
| Required production (units) | ? | ? | ? | ? | ? | ? | |
| Raw materials required to produce one unit | ? | ? | ? | ? | ? | ? | |
| Production needs (pounds) | ? | ? | ? | ? | ? | ? | |
| Add desired ending inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Total needs (pounds) | ? | ? | ? | ? | ? | ||
| Less beginning inventory of raw materials (pounds) | ? | ? | ? | ? | ? | ||
| Raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Cost of raw materials per pound | ? | ? | ? | ? | ? | ||
| Cost of raw materials to be purchased | ? | ? | ? | ? | ? | ||
| Construct the schedule of expected cash payments | Year 2 Quarter | ||||||
| 1 | 2 | 3 | 4 | Year | |||
| Accounts payable, beginning balance | ? | ? | |||||
| First-quarter purchases | ? | ? | ? | ||||
| Second-quarter purchases | ? | ? | ? | ||||
| Third-quarter purchases | ? | ? | ? | ||||
| Fourth-quarter purchases | ? | ? | |||||
| Total cash disbursements | ? | ? | ? | ? | ? | ||
|
Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them. |
|||||||
| plz show the fomula for caculation | |||||||
In: Accounting
A corporate treasurer sells $10 non-callable 5-year bonds. He sees an attractive 5-year Libor floater at L+25. The 5-year swap curve is TSY 5-year plus 20 bps. The treasurer executes an interest rate swap. What does he do? What is his position after the swap?
What is the 'asset' that the manager ends up with?
In: Finance
Athena, a 60-year-old woman, has noticed that her 85-year-old mother, Dorothy, is becoming increasingly isolated and unhappy. Dorothy does not want to spend time with her friends and every time Athena visits, Dorothy seems to want to cut the visit short. Athena knows that Dorothy has experienced changes in her vision over the last 10 years. Dorothy complains to Athena that her peripheral vision seems limited and she is unable see very well in the dark. Her doctor tells her that she is developing macular degeneration, which will further affect her vision. Also, she is having a hard time hearing what people are saying, especially at social gatherings or a restaurant. Athena understands that the senses change with age and she believes that many of the changes experienced by her mother are common for her age. But Athena is concerned about her mother’s psychological state. She doesn’t really understand why her social behavior and emotional well-being have changed. Describe how sensory related changes that occur with aging can lead to changes in quality of life, including social behavior and emotional well-being, as has happened with Dorothy. Be sure to describe the impact of both hearing loss and loss of vision.
Bullet point with brief explanation is fine. Describe in relation to late adulthood
In: Psychology
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
172,399.00 |
|
Depreciation expense |
21,600 |
22,198.00 |
|
Interest expense |
16,200 |
16,520.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
139,799.00 |
|
Net fixed assets |
376,264.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
62,655.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
336,548.00 |
|
Taxes |
9,900 |
18,574.00 |
What is the firm's current year operating profit margin?
In: Finance
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
178,722.00 |
|
Depreciation expense |
21,600 |
22,610.00 |
|
Interest expense |
16,200 |
16,173.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
138,719.00 |
|
Net fixed assets |
375,126.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
69,866.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
337,317.00 |
|
Taxes |
9,900 |
18,792.00 |
What is the current year's cash balance?
In: Finance
|
Category |
Prior year |
Current year |
|
Accounts payable |
41,400 |
45,000 |
|
Accounts receivable |
115,200 |
122,400 |
|
Accruals |
16,200 |
13,500 |
|
Additional paid in capital |
200,000 |
216,660 |
|
Cash |
??? |
??? |
|
Common Stock @ par value |
37,600 |
42,000 |
|
COGS |
131,400 |
178,722.00 |
|
Depreciation expense |
21,600 |
22,610.00 |
|
Interest expense |
16,200 |
16,173.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
138,719.00 |
|
Net fixed assets |
375,126.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
69,866.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
337,317.00 |
|
Taxes |
9,900 |
18,792.00 |
What is the current year's return on assets (ROA)?
In: Finance