Concept explainers
a.
To prepare: Cash budget of W Incorporation.
Cash Budget:
Cash budget is prepared to ascertain the amount of cash after a given period of time. Cash budget is a statement that contains the information of cash receipts and cash payments.
Closing balance of cash is calculated with the help of cash budget.
a.

Explanation of Solution
Prepare cash budget.
W Incorporation | ||||
Cash budget | ||||
($ in millions) | ||||
Particulars
|
Q1 ($) millions |
Q2 ($) millions |
Q3 ($) millions |
Q4 ($) millions |
Beginning cash balance | 32 | 37.50 | 13.1 | 16.7 |
Net cash inflows | 5.5 | (24.7) | 3.6 | 25.4 |
Ending cash balance | 37.5 | 12.8 | 16.7 | 42.1 |
Minimum cash balance | (15) | (15) | (15) | (15) |
Cumulative surplus (deficit) | 22.5 | (2.2) | 1.7 | 27.1 |
Table (1)
Working Note:
The average collection period is of 45 days, it means the cash collection is 50% of current and 50% of old balance of credit sales.
The average accounts payable period is of 36 days it means the firm has to pay 60% of current quarter purchase and 40% of previous quarter purchase in current quarter.
Table that shows calculation of
Particulars
|
Q1 ($) millions |
Q2 ($) millions |
Q3 ($) millions |
Q4 ($) millions |
Beginning receivables | 34 | 52.50 | 45 | 61 |
Sales | 105 | 90 | 122 | 140 |
Collection on account (A) | (86.5) | (97.50) | (106) | (131) |
Ending receivables | 52.5 | 45 | 61 | 70 |
Purchase | 41 | 55 | 63 | 54 |
Payment of accounts | 43.5 | 49.2 | 59.8 | 57.6 |
Wages, taxes and expenses
|
31.5 | 27 | 36.60 | 42 |
Capital expenditure | 40 | |||
Interest and dividend | 6 | 6 | 6 | 6 |
Total cash disbursement (B) | 81 | 122.2 | 102.4 | 105.6 |
Net cash inflows
|
5.5 | (24.7) | 3.6 | 25.4 |
Table (2)
Calculate collection on account receivables in Q1,
Calculation of ending receivable in Q1,
Calculation of purchase of Q1,
Calculation of payment to accounts payable in Q1,
Calculate collection on account receivables in Q2,
Calculation of ending receivable in Q2,
Calculation of purchase of Q2,
Calculation of payment to accounts payable in Q2,
Calculate collection on account receivables in Q3,
Calculation of ending receivable in Q3,
Calculation of purchase of Q3,
Calculation of payment to accounts payable in Q3,
Calculate collection on account receivables in Q4,
Calculation of ending receivable in Q4,
Calculation of purchase of Q4,
Calculation of payment to accounts payable in Q4,
b.
To prepare: A statement that shows short term financial plan and the net cash cost.
b.

Explanation of Solution
The statement of financial plan is,
Particulars
|
Q1 ($) millions |
Q2 ($) millions |
Q3 ($) millions |
Q4 ($) millions |
Beginning cash balance | 15 | 15 | 15 | 15 |
Net cash inflows | 5.5 | (24.7) | 3.6 | 25.4 |
New short term investment | (6.14) | (2.53) | (25.45) | |
Income from short term Investment | 0.34 | 0.46 | 0.05 | |
Sale of short term investment | 22.84 | |||
New short term borrowing | 1.1 | |||
Interest on short term borrowing | (0.03) | |||
Short term borrowing repaid | (1.1) | |||
Ending cash balance | 15 | 15 | 15 | 15 |
Minimum cash balance | (15) | (15) | (15) | (15) |
Cumulative surplus (deficit) | 0 | 0 | 0 | 0 |
Beginning short term Investment | 17 | 22.84 | 2.53 | |
Ending short term Investment | 22.84 | 0 | 2.53 | 28.07 |
Beginning short term debt | 0 | 0 | 1.1 | 0 |
Ending short term debt | 0 | 1.1 | 0 | 0 |
Table (3)
Calculation of net cash cost,
Working Note:
Calculation of new short term investment in Q1 is,
Calculation of income from new short term investment in Q1 is,
Calculation of beginning short term investment Q1,
Calculation of ending short term investment Q1,
Calculation of income from new short term investment in Q2 is,
Calculation of new short term borrowing Q2,
Calculation of new short term investment Q3,
Calculation of income from short term investment in Q4,
Calculation of new short term investment in Q4,
Calculation of ending short term investment Q4,
Want to see more full solutions like this?
Chapter 26 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- If value is not clear then please comment i will write values dont solve question, i will give unhelpful.arrow_forwardFinance subject question solve i need help.arrow_forwardi submitted blurr images mistakely don't amswer.If image is blurr comment please i will write values . dont give answer with incorrect values. i will unhelpful answerarrow_forward
- Need help!!!If image is blurr comment please i will write values . dont give answer with incorrect values. i will unhelpful answerarrow_forwardhelp !If image is blurr comment please i will write values . dont give answer with incorrect values. i will unhelpful answerarrow_forwardListed here, are the 2018 and 2019 balance sheets. motors. and income statements,, for Otago Bay Marine Motors, a major manufacturer of top-of-the-line outboard a. On the basis of the information provided, calculate the following financial ratios for 2018 and 2019: b. Considering the financial ratios you computed, along with the industry averages, how would you characterize the financial condition of Otago Bay Marine Motors? Explain. a. Calculate the following financial ratios for 2018 and 2019. (Round to two decimal places.) Current ratio Otago Bay Marine Motors 2019 2018arrow_forward
- I need to get more details by doing homeworks and exams.arrow_forwardUse the financial statement of DKT Enterprise provided above to calculate the ratio for 2024 that reflects each of the following conditions (where applicable, round off answers to two decimal places.): 1. The percentage of DKT Enterprises' revenue that remained after accounting for the cost of goods sold. 2. The percentage of DKT Enterprises' revenue that remained after all expenses, including operating costs, interest, and taxes, have been deducted. 3. The extent to which DKT Enterprises' short-term liabilities, were covered by assets that could be quickly converted into cash during the year. 4. The ratio of DKT Enterprises' liquid assets to its current liabilities, indicating the company's ability to meet short-term obligations without relying on inventory. 5. The percentage of the profit DKT Enterprises generated from its total assets during the year, reflecting how efficiently it utillises its asset base to generate earnings. 6. The percentage of the profit for the year relative…arrow_forwardDynamic Energy Wares (DEW) has decided to change the manner in which it distributes its products to large companies. The change in the distribution system comes at a time when DEW’s profits are declining. The declining profits might not be the sole reason for the change, but it appears to be the primary impetus for the decision. It also appears that the new policy requiring DEW’s distributors to increase inventory levels before the end of the fiscal year will artificially inflate DEW’s sales for the current year. However, DEW’s new policy does not require the distributors to pay for any increased inventory until next year (six months), and any unsold inventory can be returned after nine months. So, if the demand for DEW’s products actually is decreasing, the impact will appear on next year’s financial statements. If the financial manager actually intends to artificially inflate DEW’s profits this year, she must realize that such actions eventually will “catch up” with her. Discussion…arrow_forward
- what is distributors’ meeting?arrow_forwardWhat is ethical dilemma?arrow_forward$1.35 Million for the below question is incorrect, Machine A is $1.81 and Machine B is $0.46 Million. The Perez Company has the opportunity to invest in one of two mutually exclusive machines that will produce a product it will need for the foreseeable future. Machine A costs $8 million but realizes after-tax inflows of $4.5 million per year for 4 years. After 4 years, the machine must be replaced. Machine B costs $17 million and realizes after-tax inflows of $4 million per year for 8 years, after which it must be replaced. Assume that machine prices are not expected to rise because inflation will be offset by cheaper components used in the machines. The cost of capital is 13%. Using the replacement chain approach to project analysis, by how much would the value of the company increase if it accepted the better machine? Round your answer to two decimal places. 1.) $1.35 millionarrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning




