At the beginning of the school year, Priscilla Wescott 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) | $8,260 |
| Purchase season football tickets in September | 110 |
| Additional entertainment for each month | 290 |
| Pay fall semester tuition in September | 4,500 |
| Pay rent at the beginning of each month | 400 |
| Pay for food each month | 220 |
| Pay apartment deposit on September 2 (to be returned December 15) | 600 |
| Part-time job earnings each month (net of taxes) | 1,020 |
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign.
| Priscilla Wescott | ||||
| Cash Budget | ||||
| For the Four Months Ending December 31 | ||||
| September | October | November | December | |
| Estimated cash receipts from: | ||||
| $ | $ | $ | $ | |
| Total cash receipts | $ | $ | $ | $ |
| Less estimated cash payments for: | ||||
| $ | ||||
| $ | $ | $ | ||
| Total cash payments | $ | $ | $ | $ |
| Cash increase (decrease) | $ | $ | $ | $ |
| Cash balance at end of month | $ | $ | $ | $ |
b. Are the four monthly budgets that are
presented prepared as static budgets or flexible budgets?
c. What are the budget implications for Priscilla Wescott?
Priscilla can see that her present plan (will provide/will not provide?) sufficient cash. If Priscilla did not budget but went ahead with the original plan, she would be $________? (over/short?) at the end of December, with no time left to adjust.
In: Accounting
The annual membership fee at your health club is $750 a year and is expected to increase at 5% per year. A life membership is $7,500 and the discount rate is 12%. In order to justify taking out the life membership, what would be your minimum life expectancy?
You are considering buying a car worth $30,000. The dealer, who is anxious to sell the car, offers you an attractive financing package. You have to make a down-payment of $3,500, and pay the rest over 3 years with monthly payments. The dealer will charge you interest at a constant APR of 2%, which is lower than the market interest rate.
(1) Whatisthemonthlypaymenttothedealer?
(2) Thedealeroffersyouasecondoption:youpaycash,butgeta$2,500discount.Shouldyougofor
the loan or should you pay cash? Assume that the market annual interest rate (APR) is at 5%.
A foundation announces that it will be offering one CUHK (SZ) scholarship every year for an indefinite number of years. The first scholarship is to be offered exactly one year from now. When the scholarship is offered, the student will receive ¥100,000 annually for a period of four years, beginning from the date the scholarship is offered. This student is then expected to repay the principal amount received (¥400,000) in 10 equal annual installments, interest-free, starting two years after the last payment of the scholarship. This implies that the foundation is really giving an interest-free loan under the guise of a scholarship. The current interest is 6% and is expected to remain unchanged.
(1) What is the PV of the first scholarship (the scholarship includes both money given out to and the
repayments received from the student)?
(2) The foundation invests a lump sum to fund all future scholarships. Determine the size of the
investment today.
In: Finance
The E.N.D. partnership has the following capital balances as of the end of the current year:
Pineda $ 170,000
Adams 150,000
Fergie 140,000
Gomez 130,000
Total capital $ 590,000
Answer each of the following independent questions:
a. Assume that the partners share profits and losses 3:3:2:2, respectively. Fergie retires and is paid $168,000 based on the terms of the original partnership agreement. If the goodwill method is used, what is the capital balance of the remaining three partners?
b. Assume that the partners share profits and losses 4:3:2:1, respectively. Pineda retires and is paid $330,000 based on the terms of the original partnership agreement. If the bonus method is used, what is the capital balance of the remaining three partners? (Do not round your intermediate calculations. Round your final answers to the nearest dollar amounts.)
In: Accounting
A project will produce an operating cash flow of $445,000 a year for four years. The initial cash outlay for equipment will be $1,195,000. The net aftertax salvage value of $61,000 will be received at the end of the project. The project requires 87,000 of net working capital up front that will be fully recovered. What is the net present value of the project if the required rate of return is 12 percent? $146,800.23 $181,219.28 $154,036.37 $172,811.69 $163,677.13
In: Finance
The table contains the Sales estimates for the next year. The Purchases are 64% of Sales. Purchases are paid in the following month. The administrative expenses of $10,196 are paid each month Tax expenses of $39,003 are paid in March, June, September, and December each year. Rent expenses of $79,725 are paid in June and December. What is the cash outflow for March?
Jan- 59,595 Feb- 60,120 Mar- 20,032 Apr-68,137 May- 59,595 Jun- 60,120 Jul- 68,137 Aug-20,032 Sep-59,595 Oct-20,032 Nov-60,120 Dec-68,137
In: Finance
A project will produce an operating cash flow of $445,000 a year for four years. The initial cash outlay for equipment will be $1,195,000. The net aftertax salvage value of $61,000 will be received at the end of the project. The project requires 87,000 of net working capital up front that will be fully recovered. What is the net present value of the project if the required rate of return is 12 percent? $146,800.23 $181,219.28 $154,036.37 $172,811.69 $163,677.13
In: Finance
You are trying to value Apple’s stock as of the end of their fiscal year 2018. You’ve calculated their EBITDA from 2016 to 2018 as $61,429, $83,772, and $71,877. You’ve forecast their future EBITDA for the next five years as $81,312, $89,493, $98,496, $108,406, and $119,313. You’ve calculated their unlevered free cash flows from 2016 to 2018 as $44,932, $65,051, and $43,942. You’ve forecast their future unlevered FCFs for the next five years as $45,303, $58,936, $64,865, $71,391, and $78,574. You believe that the FCF in the first year after your forecast horizon will be $82,503, and the FCFs will grow at a constant rate of 5% forever after that time. You’ve calculated the firm’s WACC (discount rate) as 15%. The company currently has $100,000 in capital structure debt, $250,000 in total liabilities, $25,000 in cash, $100,000 in current assets, no minority interest, no employee stock options outstanding, and 3,000 shares outstanding. What is Apple’s implied stock price per share, based on this information? What is their implied price per share if you calculate the terminal value assuming an EBITDA multiple of 7? What is the implied stock price if you value the firm today using an EV/EBITDA multiple of 8? Show your work (you can do this in Excel if you’d like, just include all of your work).
If you could show me the process to this that would be greatly appreciated, Thanks
In: Finance
Consider the following.
a. What is the duration of a four-year Treasury
bond with a 10.5 percent semiannual coupon selling at par?
b. What is the duration of a three-year Treasury
bond with a 10.5 percent semiannual coupon selling at par?
c. What is the duration of a two-year Treasury
bond with a 10.5 percent semiannual coupon selling at par?
(For all requirements, do not round intermediate
calculations. Round your answers to 2 decimal places. (e.g.,
32.16))
a. Duration of the bond _______ years
b. Duration of the bond _______ years
c. Duration of the bond _______ years
In: Finance
After tallying the receipts for their first year of operation,
the owners of the Taco Barn are encouraged. Sales of their artisnal
tacos, made from such exotic ingredients as ground beef, cheese,
and beans, have been strong and seem to give hope to the coming
year. Taco sales by month are shown in the table.
Armed only with his fingers, the owner decides that the safest
forecasting approach is a linear trend line. Generate a forecast
for the year using this technique and then calculate forecast
errors using MSE. What is the mean squared error for this
forecasting approach?
1217
1033
1148
1282
In: Operations Management
1. In a study of police gunfire reports during a recent year, it was found that among 540 shots fired by New York City police, 182 hit their targets; and among 283 shots fired by Los Angeles police, 77 hit their targets.
a. Use a 0.05 significance level to tes t the claim that New York City police and Los Angeles
police have different proportion of hits.
b. Construct a 90 % confidence interval to estimate the difference between the two
proportions of hits.
In: Math