Reference no: EM132460389
Written Assessment The Brokman Company is currently working on its cash budget for the coming year. The following information is available:
Note: It is expected that this problem will be complete using an Excel spreadsheet using formulas.
Projected sales for the coming year:
Month Projected Sales Month Projected Sales
January $850,000
May 830,000
February 750,000
June 750,000
March 730,000
July 900,000
April 850,000
The collection history of the Brokman Company has been as follows:
1. f 20% of sales are collected in the month of the sale. f 60% of the sales are collected in the month following the sale.
2. f 15% of the sales are collected in the 2nd month following the sale.
3. f 5% of the sales are collected in the 3rd month following the sale.
The following information regarding costs is available:
1. f The cost of goods sold is 54% of sales
2. f Items for sale are purchased in the month of the sale.
3. f 80% of accounts payable are paid in the month following when the cost is incurred.
4. f 20% of accounts payable are paid in the 2nd month following when the cost is incurred. 12 ADDENDUM |
5. f Wages are 28% of sales and are paid currently.
6. f Annual general and administrative costs are $1,411,200 and are incurred evenly throughout the year. f Annual property taxes are $14,000 and are paid semi annually in June and October.
7. f A $10,000 cash capital purchase will be made in April. The beginning cash balance in April is expected to be $47,000.
- The Brokman Company has a policy of maintaining a minimum cash balance of $45,000. The company has an arrangement with a local bank for a line of credit that carries a 10% annual interest rate. If the ending monthly balance falls below $45,000, the company will borrow against the line of credit so that the minimum balance can be maintained. If the company has borrowed against the line of credit and a cash balance is expected to be above $45,000 at the end of a particular month, then repayments will be made bringing the cash balance down to $45,000. Interest on the line of credit is paid monthly. Assume that all line of credit transactions occur on the last day of the month.
Required:
Question 1: Prepare cash budget for the Brokman Company for the 2nd quarter of the year. Include April, May, June, and a quarter total in your budget
Issues with prescriptive authority of controlled substance
: CS/SB 614 authorizes an ARNP to prescribe, dispense, administer, or order any drug, which would include controlled substances.
|
Determine the ustons income statement
: Determine the Ustons income statement ,Uston, Co. is charged $2,000 per month for rent on the first of each month for the upcoming month.
|
Calculate the ois zero rates using continuous compounding
: Calculate the OIS zero rates using continuous compounding. Interpolate between continuously compounded rates linearly to determine rates between 6 months
|
Construct a decision matrix of the most relevant criteria
: Construct a decision matrix of the most relevant criteria. Make some assumptions and fill in the matrix. Would your decision change? Why?
|
Prepare cash budget for the brokman company
: Prepare cash budget for the Brokman Company for the 2nd quarter of the year. Include April, May, June, and a quarter total in your budget
|
Determine the value today of one of bonds
: Determine the value today of one of these bonds to an investor who requires a 14% rate of return.
|
What is the amount of the section 199a qualified business
: What is the amount of the Section 199A qualified business income deduction that Olivia can take this year?
|
What are the benefits associated with being patient advocate
: Explain the risks that nurses take when assuming an advocacy role. What are the benefits associated with being a patient advocate?
|
Which competencies may benefit you in your future
: Which competencies do you think may benefit you in your future role as an APN and why? As discussed in the lesson this week, healthcare providers must be.
|