Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BBT Pte Ltd is a manufacturing company. The sales forecasts for the following quarters are provided below as at 31 December 2019. 2020 2021 Figures

BBT Pte Ltd is a manufacturing company. The sales forecasts for the following quarters are provided below as at 31 December 2019.

2020 2021

Figures in $'million Q1 Q2 Q3 Q4 Q1

Sales 40 50 50 40 50

BBT collects 60% of revenue in cash within the quarter and the remaining credit sales are collected in the next quarter. Purchases are 50% of the following quarter's sales. 50% of these purchases are settled by cash and the remaining credit purchases are settled in the next quarter. Overheads of $5 million per quarter are paid as incurred.

Outstanding trade receivables and trade payables as at 31 December 2019 are $10 million and $8 million respectively. These are expected to be fully collected or settled by the end of Q1 2020.

BBT expects to purchase new equipment in Q2 2020 for $20 million. Depreciation expense is $2 million per quarter. BBT will also commence paying quarterly dividends of $10 million beginning from Q3 2020.

Cash balance as of 1 January 2020 is $5 million.

(a) Construct a cash budget for Q1 to Q4 of 2020. (16 marks)

(b) Mid-way through Q1 2020, a sudden global market event occurs which disrupts BBT's existing business. As a result, the sales team has revised their estimates and highlight that they will only be able to meet 25% of their initial sales forecasts for the rest of the year in 2020.

Assess and recommend three (3) options to improve the short-term liquidity situation for BBT. (9 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Investment Analysis

Authors: Richard A. DeFusco, Dennis W. McLeavey, Jerald E. Pinto, David E. Runkle

3rd edition

111910422X, 978-1119104544, 1119104548, 978-1119104223

More Books

Students also viewed these Finance questions