Create a 12 month cash flow budget in excel using the, Ask an Expert

Accounting

Create a 12 month cash flow budget in Excel using the following assumptions:

• Initial sales of $5 million, with fore-casted monthly growth of 1%

• 40% of each month's sales for cash: 30% collected the following month, 20% collected 2 months later; 8% collected 3 months later; and 2% never collected

• Initial cash balance of $350,000

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M958449

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question -a jalisco inc net credit sales of 75000 and

Question - A) Jalisco Inc. net credit sales of $75,000 and estimates that bad debts are approximately 3% of net credit sales. The yearend balance in accounts receivable is $200,000 and $2,000 of accounts receivable were ...

Question - if you earned an income of 36500 in wages and

Question - If you earned an income of $36,500 in wages and other contractual income of $42,600 working under your own ABN, making a net profit of $38,500, what would be your total assessable income?

Question - simple and compound interest computations - alan

Question - Simple and Compound Interest Computations - Alan Jackson invests $20,000 at 8% annual interest, leaving the money invested without withdrawing any of the interest for 8 years. At the end of the 8 years, Alan w ...

Question - nancy gives her grandson sean 20 acres of land

Question - Nancy gives her grandson, Sean, 20 acres of land. Her tax basis in the land is $25,000. Nancy's marginal tax rate for the current year is 45%; her grandson's is 25%. Its fair market value was $575,000 at the d ...

Question - lucky treasures enterprises issued 9 8-year

Question - Lucky Treasures Enterprises issued 9%, 8-year, $2,000,000 par value bonds that pay interest semiannually on October 1 and April 1. The bonds are dated April 1, 2013 and are issued on that date. The discount ra ...

Question - x company estimates the following for its three

Question - X Company estimates the following for its three products, A, B, and C, for 2018: A B C Revenue $47,460 $24,303 $63,666 Total variable costs 29,400 18,224 26,136 Fixed costs in 2018 are expected to be $19,800 ...

Question - from the information below bank reconciliation

Question - From the information below, bank reconciliation for the month of January 2015. (a) January 31, 2015 cash balance per book for the company is $35,342.02 (b) Bank statement balance at January 31, 2015 is $33,017 ...

Question - yourco inc manufactures and sells two products

Question - Yourco Inc. manufactures and sells two products. Relevant per unit data concerning each product follow. Product Basic Deluxe % of sale 25% 75% Selling price $40 $48 Variable costs 55% 50% 1) Compute the weight ...

Question - explain legislation and statutory requirements

Question - Explain legislation and statutory requirements and industry codes of practice including(Australia): Consumer credit code Privacy act Credit act Financial transaction reports act Corporations act (including acc ...

Question - colorado corporation was organized on january 1

Question - Colorado Corporation was organized on January 1, 2006, with the investment of $250,000 in cash by its stockholders. The company immediately purchased an office building for $300,000, paying $210,000 in cash an ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert