EDIT*** close up of requirements and data table. omework asps/homeworkld 4442078
ID: 2581625 • Letter: E
Question
EDIT*** close up of requirements and data table.
omework asps/homeworkld 444207878questionld 1aflushed fabedeld 463740back Dossignments.aspa Managerial Accounting F17 Homework: P9-62A Score: 1 61 of 4 pts & P9-62A (similar to) HYV Score: 4028%, 1 61 of 4 pts Question Hep * Tune Medical Supply has appled for a loan First National Bank has requested a budgeted balance sheet as of April 30, and a combined cash budgot for Apil As Tune Medical Supply's controller, you have avsembled the following Data Table -Requrements a. March 31 equipment balance $52,400, accumulated depreciation $41,500 b. Agril capital expenditures of $42.400 budgeted for cash purchase of equipment c. April depreciation expense $700 d, cost of goods sold 60% of sales e, other Agril operating expenses, in luding income tax, total $14200 25% of which wil be paid in cash 1. Prepare the budgeted balance sheet for Tune Medical Supply at April 30 Show separate computations for cash inventory, and owners'equity balances 2 Prepare the combined cash budget for Apl 3. Suppose Tuna Medicall Supply has become aware of more elficient (and more expensive equipment than budgeted for purchase in April what the total amount of cash avalable for equipment purchases in April, before financing, if the minimum desied ending cash balance is 19.0002 (F or this requrement, disregard the $42 400 initialy budgeted for equipment and the remainder accrued at April 30 f. March 31 owners' equity. $91800 g March 31 cash balance $40,100 h, Agri budgeted sales $87.00075% of which is for cash rhe "onaling 25%, haldbeelededin 4 Before granting a loan to Tune Medical Supply First National Bank asks for a sensiltiuity analysis assuming that April sales are only $58,000 sather than the $87 000 originally budgeted (While the cost of goods sold will change, assume that purchases, depreciation and the other operating April and hall in May i. Agrl cash collections on March sales $29 200 i April cash payments of March 31 Sabilities incurred for Manch punchases of inventory $17,700 k. March 31 inventary balance. 529 300 L. Agil purchases of inventory 510.200 for cash and 536,800 on aredi Half of the credit purchases w Prepare a revised budgeted balance sheet for Tune Medical Supply showing separate computations for cash, inventory. and owners equity balances a. b. Suppose Tune Medical Supply has a minimum desired cash balance of $19 000 Wlthe company need to bonew cash in Apln be paid in April and half in May Prit Done OP esdtsExplanation / Answer
2.
4.b
no company need to borrow extra cash.
4a inventory
cash budget for april particulars amount explanation opening balance 40100 april sales-cash collection 76125 (0.75*87000)+(0.25/2*87000) march sales collection 29200 capital expenditure -42400 income tax paid -3550 0.25*14200 cash payment for march purchase -17700 cash payment for april purchase -28600 10200+(0.50*36800) CLOSING BALANCE 53175Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.