Given the following, complete the tableCash Receipts increase by 4% every month. A Cash Disbursements is 60% of the total monthlycash receipts and The minimum cash balance per month is P 60,000.Cash BudgetJanFebMarAprMayJunCash ReceiptsP 77,000.00Less: CashDisbursementsNet Cash FlowP 34,800.00Add: Beginning CashEnding CashLess: Minimum CashBalanceRequired TotalFinancing / Excess CashBalance

A budget is part of financial accounting that involves the estimation of revenues, expenditures, and…

Answered: Given the following, complete the table…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

The management of MNGO Corporation is currently evaluating if they will need to borrow funds for their fourth quarter operation. Below are the different forecasted cash inflows and outflows of MNGO Corporation for the fourth quarter of the year Forecasted sales for October, November and December are $100,000, $150,000, and $ 180,000 respectively. Based on experience 40% is on cash sales, 40% is collected the following month and the remaining 20% is collected after 2 months when sales was made. It is expected that the company will be receiving $10,000 from its investments on Marketable securities on December. A scrap value of $3,000 is expected to be received by the company on November for the sales of depreciated assets. Monthly cash purchases on inventory is estimated to be 35% of monthly sales. Payment of accounts payable is done monthly which is 10% of the previous months sales. Monthly salary and wages are paid in cash amounting to $20,000 Monthly estimated utilities expense is…
Hurzdan, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company currently has on hand. The company currently has a receivables balance of $189 million and has developed the following sales and cash disbursement budgets (in millions): Q2 Sales $450 Total cash disbursement 268 390 Beginning receivables Sales Cash collections Ending receivables Total cash collections Total cash disbursements Net cash inflow Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Q1 $378 Complete the following cash budget for the company. (A negative answer should be Indicated by a minus sign. Do not round Intermediate calculations and enter your answers in millions rounded to the nearest whole million dollar amount, e.g., 32.) + Q3 Q4 $531 $495 412 617 Q1 HURZDAN, INC. Cash Budget (in millions) 378 268 Q2 450 390 Q3 531 617 Q4 495 412
cO X HAS cASH BALANCE OF $33 AND SHORT TERM LOAN BALANCE OF $200 AT THE BEGINNING OF QTR 1. THE NET CASH INFLOW FOR THE 1ST QTR IS $89 AND THE FOR THE SECOND QTR THERE IS A NET CAHS OUTFLOW OF $44. aLL CASH SHORTFALLS ARE FUNDED WITH SHORT TERM DEBT. THE FIRM PAYS 2% OF ITS PRIOR QUARTERS ENDING LOAN BALANCE AS INTERST EACH QUARTER. THE MINIMUM CASH BALANCE IS $25. wHAT IS THE SHORT TERM LOAN BALANCE AT THE END OF THE YEAR? available anwsers are 107 111 121 128 133
Given the following information about cash management of the Evergreen Company: Average cash payment is $120,000 per month. The company invests spare cash in Treasury Bills at an annual interest rate of 3.90%. The cost of each transaction of Treasury bills is $25. What is the average cash balance of the Evergreen Company? (no excel pls) a. $21,483 b. $12,403 c. $8,771 d. $15,191 e. $42,967
Average account receivables-60 days, Inventories-85 days, Average account payable-55 days Company spends Rs.21, 00,000 annually and can earn 10% on its investments. (i) Find out cash cycle and cash turnover assuming 360 days in a year, (ii) Minimum amount of cash required to meet the payment. Also calculate the above, if inventory age is reduced to 75 days. What will be the savings for the company?
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)
Problem 2. Lexberville Company expects to make even monthly cash payments of P166,666.67 during the year. The average return on money market placements is 8% p.a. and payment for cash transfer is expected to be P242 per transaction. Requirements: 5. Transaction cost at the optimum cash balance. (round to nearest whole number) 6. Transaction cost at P40,000 cash balance. 7. Opportunity cost at P500,000 cash balance.
Suppose that the Sales in December 2019 were 86,536. The sales are expected to grow by 9% in January 2020, by 14% in February 2020, and by 15% in March 2020. After that, the sales are expected to grow by 10%. The company's cash collection is as follows: 60% is collected in the same month and the remainder in the next month. What is the cash collection for June, 2020?
The following table shows CLV for A company. What is the CLV of the first year (please round it up)? Profit per Annual Customer Annual Year CustomerRetention Accounts Discount Discount ($) Probability RemainingRate 0 1 50 2 70 3 ↑ 75 41 42 43 44 45 90% 87% 85% 100 90 78.3 66.5 0.1 0.1 Cumulative Discounted Cash Flow ($)0 0.1 Factor 0.91 0.83 0.75
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
Calculate Cash Conversion Cycle (CCC) from the following; Average collection period 30 Average payment period - 20 Average inventory -6,000 COGS per day - 150 a. 70 days b. 90 days c. 30 days d. 50 days
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS