| Category | Prior Year | Current Year |
| Accounts payable | 3,148.00 | 5,978.00 |
| Accounts receivable | 6,987.00 | 9,075.00 |
| Accruals | 5,679.00 | 6,062.00 |
| Additional paid in capital | 19,911.00 | 13,723.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,424.00 | 18,276.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 983.00 | 959.00 |
| Interest expense | 1,262.00 | 1,152.00 |
| Inventories | 3,018.00 | 6,677.00 |
| Long-term debt | 17,000.00 | 22,791.00 |
| Net fixed assets | 75,310.00 | 74,221.00 |
| Notes payable | 4,066.00 | 6,554.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,527.00 | 34,370.00 |
| Sales | 46,360 | 45,467.00 |
| Taxes | 350 | 920 |
What is the firm's cash flow from financing?
Submit
Answer format: Number: Round to: 0 decimal places.
| Category | Prior Year | Current Year |
| Accounts payable | 3,148.00 | 5,978.00 |
| Accounts receivable | 6,987.00 | 9,075.00 |
| Accruals | 5,679.00 | 6,062.00 |
| Additional paid in capital | 19,911.00 | 13,723.00 |
| Cash | ??? | ??? |
| Common Stock | 2,850 | 2,850 |
| COGS | 22,424.00 | 18,276.00 |
| Current portion long-term debt | 500 | 500 |
| Depreciation expense | 983.00 | 959.00 |
| Interest expense | 1,262.00 | 1,152.00 |
| Inventories | 3,018.00 | 6,677.00 |
| Long-term debt | 17,000.00 | 22,791.00 |
| Net fixed assets | 75,310.00 | 74,221.00 |
| Notes payable | 4,066.00 | 6,554.00 |
| Operating expenses (excl. depr.) | 19,950 | 20,000 |
| Retained earnings | 35,527.00 | 34,370.00 |
| Sales | 46,360 | 45,467.00 |
| Taxes | 350 | 920 |
What is the firm's total change in cash from the prior year to the current year?
In: Accounting
|
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 |
170,550.00 |
|
Depreciation expense |
21,600 |
22,669.00 |
|
Interest expense |
16,200 |
16,971.00 |
|
Inventories |
111,600 |
115,200 |
|
Long-term debt |
135,000 |
139,896.00 |
|
Net fixed assets |
379,919.00 |
399,600 |
|
Notes payable |
59,400 |
64,800 |
|
Operating expenses (excl. depr.) |
50,400 |
64,100.00 |
|
Retained earnings |
122,400 |
136,800 |
|
Sales |
255,600 |
338,777.00 |
|
Taxes |
9,900 |
19,248.00 |
What is the current year's return on assets (ROA)?
In: Finance
|
Property type |
Price |
Mortgage |
Expected |
Estimated |
|
|---|---|---|---|---|---|
|
Rental income |
Depreciation expense |
resale |
|||
|
(per year) |
(per year) |
value |
|||
| Strip shopping center | $800,000 | $448,000 | $136,016 | $7,692 | $912,000 |
| Small apartment complex | $650,000 | $292,500 | $91,281 | $8,273 | $685,100 |
The first potential investment consists of a seven-store shopping center, which has a current market price of $800,000. Of this amount, $200,000 represents the cost of the land, and the balance, $600,000, is attributable to buildings on the property. The second possible investment, which costs $650,000, consists of a small four-unit apartment complex. $195,000 of the investment's total price is reflects the cost of land, and the remaining $455,000 is associated with structures on the land. For both properties, you believe you can increase the rents 2% per year for each of the next four years, and expect to sell either property at the end that time. You desire a return of 7% on your investments.
Assume that your expected annual operating costs—excluding your annual depreciation expense—for the commercial property will be 35% of your annual rental income. For the residential property, the annual operating costs (excluding depreciation expense) will be 20% of your annual rental income. The interest rates of the mortgages for the commercial and residential lease properties are expected to be 6% and 4%, respectively.
Given your other assumptions, complete the following two tables and then use your computations to answer several questions. Round all amounts to the nearest whole dollar. (Hint: Don’t round intermediate calculations. Also, don’t forget that capital gains are taxed at 15% if properties are sold for more than their original purchase price.)
|
Strip shopping center |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
|---|---|---|---|---|
| Annual rental income | ||||
| Estimated resale value | 0 | 0 | 0 | |
| Less: Annual operating expenses | ||||
| Less: Annual depreciation expense | ||||
| Less: Annual interest payments (6%) | 26,880 | 25,536 | 24,192 | 22,848 |
| Less: Taxes (25%) | ||||
| Less: Capital gains tax (15%) | 0 | 0 | 0 | |
| Net profit | ||||
| Interest factor (7%) | 0.9346 | 0.8734 | 0.8163 | 0.7629 |
| PV of Cash flow | ||||
| Total PV of Cash flows |
The net discounted return expected from an investment in the shopping center—after deducting the cost of the investment—is ( $30,991, $830,991, $55784, $24,793) .
In: Finance
| Item | Prior year | Current year |
| Accounts payable | 8,102.00 | 7,809.00 |
| Accounts receivable | 6,028.00 | 6,680.00 |
| Accruals | 983.00 | 1,392.00 |
| Cash | ??? | ??? |
| Common Stock | 11,946.00 | 12,572.00 |
| COGS | 12,688.00 | 18,343.00 |
| Current portion long-term debt | 4,928.00 | 5,020.00 |
| Depreciation expense | 2,500 | 2,820.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,260.00 | 4,775.00 |
| Long-term debt | 13,063.00 | 14,127.00 |
| Net fixed assets | 50,599.00 | 54,949.00 |
| Notes payable | 4,309.00 | 9,861.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,053.00 | 30,112.00 |
| Sales | 35,119 | 46,621.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,159.00 | 7,896.00 |
| Accounts receivable | 6,010.00 | 6,644.00 |
| Accruals | 957.00 | 1,541.00 |
| Cash | ??? | ??? |
| Common Stock | 10,381.00 | 12,875.00 |
| COGS | 12,661.00 | 18,004.00 |
| Current portion long-term debt | 5,054.00 | 5,069.00 |
| Depreciation expense | 2,500 | 2,844.00 |
| Interest expense | 733 | 417 |
| Inventories | 4,158.00 | 4,797.00 |
| Long-term debt | 14,968.00 | 13,143.00 |
| Net fixed assets | 50,662.00 | 54,550.00 |
| Notes payable | 4,383.00 | 9,863.00 |
| Operating expenses (excl. depr.) | 13,977 | 18,172 |
| Retained earnings | 28,503.00 | 29,396.00 |
| Sales | 35,119 | 45,618.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
| Chapter 8: 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 | ? | ? | ? | ? | ? | ||
In: Accounting
| U.S. Civilian Labor Force (thousands) | ||||
| Year | Labor Force | Year | Labor Force | |
| 2007 | 189,002 | 2012 | 190,712 | |
| 2008 | 189,739 | 2013 | 190,235 | |
| 2009 | 188,195 | 2014 | 191,322 | |
| 2010 | 188,734 | 2015 | 193,041 | |
| 2011 | 189,079 | 2016 | 194,724 | |
Click here for the Excel Data File
(a) Make a line graph of the U.S. civilian labor
force data.
| Line Graph A | Line Graph B | Line Graph C | Line Graph D |
Line Graph 1
Line Graph 2
Line Graph 3
Line Graph 4
(b) Describe the trend (if any) and discuss possible
causes.
Trend is (Click to
select) positive negative . There
seems to be an (Click to
select) increase decrease in the
rate of growth over the past few years.
(d) Make forecasts using the following fitted
trend models for years 2017-2019. (Round your answers to
the nearest whole number.)
| t | Linear | Quadratic | Exponential |
| 11 | |||
| 12 | |||
| 13 |
In: Economics
Martin Martindale, the 40-year-old founder and president of Martindale Corporation (an accrual-basis, calendar-year C corporation), owns 60 percent of the stock and receives a salary of $600,000. Four unrelated shareholders own the rest of the stock equally. The corporation has paid dividends regularly to the shareholders and plans to continue to do so in the future. Martin plans to recommend that the board of directors authorize the payment of a bonus to himself and two other employees (all cash-basis, calendar-year individuals). The first employee is the vice president, who owns 10 percent of the corporation and receives a salary of $400,000. The other employee is the controller, who is not currently a shareholder in the corporation and receives a salary of $200,000. Martin would like the bonus to equal 75 percent of each recipient’s current salary. Martin believes that the total compensation is probably a little high when compared to the corporation’s competitors but Martindale is much more profitable. Martindale’s profits have increased by more than 20 percent in the last two years due to the efforts of the individuals who will receive the bonuses, while other businesses in the same industry showed an increase in profits of less than 10 percent. Martin asks you, as the corporation’s tax advisor, to recommend what the corporation needs to do so that it gets a deduction for the planned bonuses. Martin would prefer to pay the bonuses next year but deduct them this year.
In: Operations Management
Chief Complaint: 74-year-old woman with shortness of breath and swelling.
History: Martha Wilmington, a 74-year-old woman with a history of rheumatic fever while in her twenties, presented to her physician with complaints of increasing shortness of breath ("dyspnea") upon exertion. She also noted that the typical swelling she's had in her ankles for years has started to get worse over the past two months, making it especially difficult to get her shoes on toward the end of the day. In the past week, she's had a decreased appetite, some nausea and vomiting, and tenderness in the right upper quadrant of the abdomen.
On physical examination, Martha's jugular veins were noticeably distended. Auscultation of the heart revealed a low-pitched, rumbling systolic murmur, heard best over the left upper sternal border. In addition, she had an extra, "S3" heart sound.
Top of Form
Questions:
1. What is causing this murmur?
2. What is causing her "S3" heart sound?
3. Is her history of rheumatic fever relevant to her current
symptoms? Explain.
4. A chest X-ray reveals a cardiac silhouette that is normal in
diameter. Does this rule out a possible problem with Martha's
heart? Explain.
In: Anatomy and Physiology
Chief Complaint: 74-year-old woman with shortness of breath and swelling. History: Martha Wilmington, a 74-year-old woman with a history of rheumatic fever while in her twenties, presented to her physician with complaints of increasing shortness of breath ("dyspnea") upon exertion. She also noted that the typical swelling she's had in her ankles for years has started to get worse over the past two months, making it especially difficult to get her shoes on toward the end of the day. In the past week, she's had a decreased appetite, some nausea and vomiting, and tenderness in the right upper quadrant of the abdomen. On physical examination, Martha's jugular veins were noticeably distended. Auscultation of the heart revealed a low-pitched, rumbling systolic murmur, heard best over the left upper sternal border. In addition, she had an extra, "S3" heart sound. Top of Form
5. You examine Martha's abdomen and find that she has an enlarged liver ("hepatomegaly") and a moderate degree of ascites (water in the peritoneal cavity). Explain these findings. 6. Examination of her ankles reveals significant "pitting edema." Explain this finding. 7. She is advised to wear support stockings. Why would this help her? 8. Which term more accurately describes the stress placed upon Martha's heart -- increased pre-load or increased afterload? 9. What is the general term describing Martha's condition? 10. How might Martha's body compensate for the above condition? 11. Martha is started on a medication called digoxin. Why was she given this medication, and how does it work? 12. Two weeks after starting digoxin, Martha returns to the physician's office for a follow-up visit. On physical examination, she still has significant hepatomegaly and pitting edema, and is significantly hypertensive (i.e. she has high blood pressure). Her physician prescribes a diuretic called furosemide (or "Lasix"). Why was she given this
In: Anatomy and Physiology