Personal Budget
At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
| Cash balance, September 1 (from a summer job) | $6,430 |
| Purchase season football tickets in September | 90 |
| Additional entertainment for each month | 220 |
| Pay fall semester tuition in September | 3,500 |
| Pay rent at the beginning of each month | 310 |
| Pay for food each month | 180 |
| Pay apartment deposit on September 2 (to be returned December 15) | 400 |
| Part-time job earnings each month (net of taxes) | 800 |
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign.
| KATHERINE MALLOY | ||||
| Cash Budget | ||||
| For the Four Months Ending December 31 | ||||
| September | October | November | December | |
| Estimated cash receipts from: | ||||
| Part-time job | $ | $ | $ | $ |
| Deposit | ||||
| Total cash receipts | $ | $ | $ | $ |
| Estimated cash payments for: | ||||
| Season football tickets | $ | |||
| Additional entertainment | $ | $ | $ | |
| Tuition | ||||
| Rent | ||||
| Food | ||||
| Deposit | ||||
| Total cash payments | $ | $ | $ | $ |
| Overall cash increase (decrease) | $ | $ | $ | $ |
| Cash balance at beginning of month | ||||
| Cash balance at end of month | $ | $ | $ | $ |
Feedback
Sometimes an item may be a decrease in one period and an increase in a different period.
Review the definitions of static budgets and flexible budgets.
What weaknesses are shown by this cash budget?
b. Are the four monthly budgets that are
presented prepared as static budgets or flexible budgets?
Static
c. Malloy can see that her present plan will not provide sufficient cash. If Malloy did not budget but went ahead with the original plan, she would be $ short at the end of December, with no time left to adjust.
In: Accounting
Equipment with a ten-year estimated useful life and no salvage value is sold at the end of the third year of its useful life. How would using the straight-line method of depreciation instead of the double-declining balance method of depreciation affect revenues and expenses?
In: Accounting
|
Markus Company’s common stock sold for $2.75 per share at the end of this year. The company paid a common stock dividend of $0.55 per share this year. It also provided the following data excerpts from this year’s financial statements |
|
Ending Balance |
Beginning Balance |
|||
| Cash | $ | 35,000 | $ | 30,000 |
| Accounts receivable | $ | 60,000 | $ | 50,000 |
| Inventory | $ | 55,000 | $ | 60,000 |
| Current assets | $ | 150,000 | $ | 140,000 |
| Total assets | $ | 450,000 | $ | 460,000 |
| Current liabilities | $ | 60,000 | $ | 40,000 |
| Total liabilities | $ | 130,000 | $ | 120,000 |
| Common stock, $1 par value | $ | 120,000 | $ | 120,000 |
| Total stockholders’ equity | $ | 320,000 | $ | 340,000 |
| Total liabilities and stockholders’ equity | $ | 450,000 | $ | 460,000 |
| This Year | ||
| Sales (all on account) | $ | 700,000 |
| Cost of goods sold | $ | 400,000 |
| Gross margin | $ | 300,000 |
| Net operating income | $ | 140,000 |
| Interest expense | $ | 8,000 |
| Net income | $ | 92,400 |
1. What is the return on total assets (assuming a 30% tax rate)? (Round percentage answer to 1 decimal place. i.e., 0.123 should be considered as 12.3%)
2. What is the return on equity? (Round your answer to the nearest whole percentage place. i.e., 0.1234 should be considered as 12%)
3. What is the book value per share at the end of this year? (Round your answer to 2 decimal places.)
4. What is the average collection period? (Use 365 days in a year. Round your intermediate and final answers to 2 decimal places.)
5. What is the equity multiplier? (Round your answer to 2 decimal places.)
In: Accounting
As part of President Trump’s first and second year in office and during the recent discussions
of the American Health Care Act, there has been a lot of policy discussion about Obamacare. Using
the rationales for government intervention, give at least one rationale for why the
government should intervene in health insurance.
In: Economics
What is the price value of a basis point (DV01) for a 10 year 6% Treasury bond trading at par?
In: Finance
Normally, capital gains earned in the mutual fund during the year are paid out to the investor as capital gains, at the end of the year.
REQUIRED:
In: Finance
Consider a 4-year lease for a $ 250000 bottling machine, with a residual market value of $ 87500 at the end of 4 years. If the risk-free interest rate is 5.4 % APR with monthly compounding, compute the monthly lease payment in a perfect market for the following leases:
a. A fair market value lease.
b. A $ 1.00 out lease.
c. A fixed price lease with an $ 58000 final price
In: Finance
At the end of its fiscal year, the adjusted trial balance of Carla Vista Company is as follows: CARLA VISTA COMPANY Adjusted Trial Balance July 31, 2017 Debit Credit Cash $4,560 Accounts receivable 11,420 Prepaid rent 500 Supplies750 Debt investments8,000 Equipment19,950 Accumulated depreciation—equipment $5,700 Patents 18,300 Accounts payable 4,275 Interest payable 750 Unearned revenue 2,050 Notes payable (due on July 1, 2019) 45,900 B. Carla Vista, capital 28,285 B. Carla Vista, drawings 16,800 Service revenue74,900 Interest revenue320 Depreciation expense2,850 Interest expense3,000 Rent expense18,550 Salaries expense36,650 Supplies expense20,850 $162,180 $162,180 Make an income statement for the year. Mr. Carla Vista invested $5,000 cash in the business during the year. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) CARLA VISTA COMPANY Income Statement $ $ $ Make a statement of owner's equity for the year. Mr. Carla Vista invested $5,000 cash in the business during the year. (List items that increase owner's equity first.) CARLA VISTA COMPANY Statement of Owner's Equity $ : : $ $ Make a classified balance sheet at July 31, 2017. (List Current Assets in order of liquidity.) CARLA VISTA COMPANY Balance Sheet Assets $ $ : $ Liabilities and Owner's Equity $
In: Accounting
If your grandmother’s estate will pay you $280 a year for 7 years, at an interest rate of 6%, what will the present value of these payments?
In: Finance
A firm is considering a $12,000 risky project. The expected cash flows are $3,000 in year 1, $5,000 in year 2, and $7,000 in year 3. The firm's cost of capital is 11%, but the financial manager uses a hurdle rate of 9% for less-risky projects and 13% for riskier projects. Should the firm invest in this riskier project?
No, the NPV is -$578.05
No, the NPV is -$120.85
Yes, the NPV is $578.05
Yes, the NPV is $120.85
Yes, the NPV is $365.98
In: Finance