Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. Andaz Company is drafting the required cash requirements for November and December 2015. Information on past sales and sales forecasts are as follows: September

A. Andaz Company is drafting the required cash requirements for November and December 2015. Information on past sales and sales forecasts are as follows: September $90,000 October $120,000 November $80,000 December $150,000 The following is other information about Andaz Company:  60 percent of sales are in cash and the balance is collected the following month.  The monthly purchase cost is 80 per cent of the sales value of the month where 70 per cent of the purchase is paid in cash and the balance is paid in the following month.  Business site rent is RM8,000 per month.  The company plans to buy equipment worth $25,000 in November. This equipment will be depreciated by $5,000 annually.  For each loan made to finance the monthly cash requirement will be charged annual interest of 12 percent on the value of the loan accumulated and repaid starting the following month.  Andaz Company sets a minimum balance of $5,000 per month.  The balance at the end of October is $7,500. Prepare a cash budget for November and December 2015 for Andaz Company. Use the table provided to answer this question.
Cash Budget for Andaz Company for November and December 2015
November Disember
Income
Cash Sales (60% x sales)
Credit Sales (40% x last month's sales)
 Total cash inflows 
Expenses
Cash purchase
 Credit purchase
Rent
Equipment
Benefits
Total cash outflow 
Early balance
Cash flow difference
Cash balance
Minimum balance
Loan (loan payment)
Final balance

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

Revealing The Invisible How Our Hidden Behaviors Are Becoming The Most Valuable Commodity Of The 21st Century

Authors: Thomas Koulopoulos ,George Achillias

1st Edition

1682616193, 978-1682616192

More Books

Students also viewed these Finance questions