Exercise 7 (Cash Budget Analysis)A cash budget, by quarters, is given below for a retail company (000 omitted).The company requires a minimum cash balance of P5,000 to start each quarter.Quarter34YearCash balance, beginningP 9P ?P ?P ?P ?125391Add collections from customersTotal cash available85_?Less disbursements:Purchase of inventory.405832?Operating expenses4254180Equipment purchases108.36DividendsTotal disbursements110Excess (deficiency) of cash availableover disbursements(3)30Financing:Borrowings? 20?Repayments (including interest)*(?)(7)(?)1.Total financingCash balance, endingP ? P ?P 2P 2P 2* Interest will total P4,000 for the year.Required:Fill in the missing amounts in the table above.8

Cash Budget:- It is a company's estimation of cash inflow and outflow over a period of time which…

A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 3. 4 Year P ? P ? P ? P ? Cash balance, beginning P 9 125 391 Add collections from customers Total cash available 85 Less disbursements: 58 32 Purchase of inventory. Operating expenses Equipment purchases 40 42 54 180 10 8. 8. 36 Dividends 2 Total disbursements 110 Excess (deficiency) of cash available over disbursements (3) 30 Financing: Borrowings 20 Repayments (including interest)* (?) (7) (?) Total financing Cash balance, ending P ? P ? P ? P 2 P 2 * Interest will total P4,000 for the year. Required: Fill in the missing amounts in the table ahove

A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 3. 4 Year P ? P ? P ? P ? Cash balance, beginning P 9 125 391 Add collections from customers Total cash available 85 Less disbursements: 58 32 Purchase of inventory. Operating expenses Equipment purchases 40 42 54 180 10 8. 8. 36 Dividends 2 Total disbursements 110 Excess (deficiency) of cash available over disbursements (3) 30 Financing: Borrowings 20 Repayments (including interest)* (?) (7) (?) Total financing Cash balance, ending P ? P ? P ? P 2 P 2 * Interest will total P4,000 for the year. Required: Fill in the missing amounts in the table ahove

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Please do not give solution in image format thanku
CASH BUDGET; REQUIRED: Prepare a schedule showing cash collections during October. Prepare cash disbursements (payments) during October. Assuming that company had $150,000 cash balance as of October 1, calculate cash balance as of October 31. Company’s accounts receivable collection experience is as follows: Cash collected from current month’s sales; terms 1/10 n/30: 20% Cash collected from prior month’s sales (no discount) 65% Cash collected from sales two months ago: 13% Uncollectible receivables 2% Company’s estimated credit sales (company has no cash sales): July $480,000 August 420,000 September 370,000 October 350,000 November 400,000 Company’s…
Please do not give solution in image format thanku
Manji
DO NOT GIVE SOLUTION IN IMAGE
Don't give answer in image format
Dog
Gomez is considering a $200,.000 investment with the following net cash flows. Gomez requires a 15% return on its investments. (PV of $1. EV of $1. PVA of $1, and EVA of $1) (Use appropriate factor(s) from the tables provided.) Year 1 Year 2 Year 3 Year 4 Year 5 Net cash flows $76, 800 $59,000 S100,000 $173,000 $41,000 (a) Compute the net present value of this investment. (b) Should Gomez accept the investment? Complete this question by entering your answers in the tabs below. Required A Required B Compute the net present value of this investment. (Round your answers to the nearest whole dollar.) Present Value of 1 at 15% Present Value of Net Cash Flows Net Cash Year Flows Year 1 Year 2 Year 3 Year 4 Year 5 Totals Initial investment Net present value Required B > K Hequirod A
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $4,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Cash balance, beginning Add collections from customers Total cash available Less disbursements: Quarter (000 omitted) (000 omitted) 1 2 3 4 Year 6 $ 4 $ 4 $ 4 6 Assessment Tool iFrame 63 96 108 104 369 69 100 112 108 375 Purchase of inventory 47 Selling and administrative expenses 15 530 57 51 31 186 32 30 21 98 Equipment purchases 10 9 22 10 51 Dividends 2 2 2 2 8 Total disbursements Excess (deficiency) of cash available over disbursements 74 100 105 64 343 (5) (1) 7 44 32 Financing: Borrowings Repayments (including interest) * Total financing 9 6 14 (2) (13) (15) 9 6 (2) (13) (1) Cash balance, ending $ 4 $ 4 $ EA 5 31 31 *Interest will total $1,000 for the year.
Denger
Please do not give solution in image format thanku
The company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?