Preparation of cash budget Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2013 to make sure they can
cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outflows. These percentages are based on their take-home pay (that is, monthly utilities normally run 5% of monthly take-home pay). The information in the following table can be used to create their fourth-quarter budget for 2013.IncomeMonthly take-home pay $4,900ExpensesHousing 30%Utilities 5%Food 10%Transportation 7%Medical/dental .5%Clothing for October and November 3%Clothing for December $440Property taxes (November only) 11.5%Appliances 1%Personal care 2%Entertainment for October and November 6%Entertainment for December $1,500Savings 7.5%Other 5%Excess cash 4.5%a. Prepare a quarterly cash budget for Sam and Suzy covering the months Octoberthrough December 2013.b. Are there individual months that incur a deficit?c. What is the cumulative cash surplus or deficit by the end of December 2013?
1 answer:
You might be interested in
Answer:
a) The expected return of equally weighed portfolio is 14.23%
b) The expected return of equally weighed portfolio is 16.45%, hence Variance = 1.596457%
Explanation:
See workings of a and b attached in a form of spreadsheet.
Answer:
$22.2222, $9.5238, respectively
Explanation:
The market-to-book ratio is given by a share's market value divided by its book value, if shares are selling for $100 on the market, the book value is:
The price to earnings ratio (PE ratio) is determined as a share's price divided by the earnings per share. Earnings per share are:
The book value per share and earnings per share are $22.2222, $9.5238, respectively