Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Submitted by tjlecount_1 on Sun, 2012-02-26 18:37
due date not specified
answered 6 time(s)
Hand shake with shahimermaid: Complete
Hand shake with humblejeff: Complete
tjlecount_1 is willing to pay $10.00
tjlecount_1 bought 3 out of 3 answered question(s)

other students are interested:
inferes0329 on Tue, 28 Feb 2012 for $15.00
hpgoods on Tue, 20 Mar 2012 for $50.00
suave37203 on Wed, 21 Mar 2012 for $20.00
liberia708 on Sat, 24 Mar 2012
xpsalas32 on Mon, 21 May 2012
RAJV47 on Tue, 22 May 2012
rash on Sun, 27 May 2012 for $5.00
sudent1184 on Sat, 08 Sep 2012
carlin on Sun, 15 Jul 2012
17 anonymous students showed interest

Assignment 2: Course Project—Genesis Cash Budget ReportThe Genesis operations management team is now preparing to implement the operating expansion plan....

Assignment 2: Course Project—Genesis Cash Budget Report

The Genesis operations management team is now preparing to implement the operating expansion plan. Previously the firm’s cash position did not pose a challenge. However, the planned foreign expansion requires Genesis to have a reliable source of funds for both short-term and long-term needs.

One of Genesis’s potential lenders tells the team that in order to be considered as a viable customer, Genesis must prepare and submit a monthly cash budget for the current year and a quarterly budget for the subsequent year. The lender will review the cash budget and determine whether or not Genesis can meet the loan repayment terms. Genesis’s ability to repay the loan depends not only on sales and expenses but also on how quickly the company can collect payment from customers and how well it manages its supplier terms and other operating expenses. The Genesis team members agreed that being fully prepared with factual data would allow them to maximize their position as well as negotiate favorable financing terms.

The Genesis management team held a brainstorming session to chart a plan of action, which is detailed here.

Evaluate historical data and prepare assumptions that will drive the planning process.

Produce a detailed cash budget that summarizes cash inflow, outflow, and financing needs.

Identify and compare interest rates, both short-term and long-term, using debt and equity.

Analyze the financing mix (short/long) and the cost associated with the recommendation.

Since this expansion is critical to Genesis Corporation expanding into new overseas markets, the operations management team has been asked to prepare an executive summary with supporting details for Genesis’s senior executives.

Working over a weekend, the management team developed realistic assumptions to construct a working capital budget.

Sales: The marketing expert and the newly created customer service personnel developed sales projections based on historical data and forecast research.

Other cash receipt: Rental income $15,000 per month.

Production material: The production manager forecasted material cost based on cost quotes from reliable vendors, the average of which is 50 percent of sales.

Other production cost: Based on historical cost data, this cost on an average is 30 percent of the material cost and occurs in the month after material purchase.

Selling and marketing expense: Five percent of sales

General and administrative expense: Twenty percent of sales

Interest payments: Payable in December – $75, 000

Tax payments: Quarterly due 15th of April, July, October, and January – $15,000

Minimum cash balance desired: – $ 25,000 per month

Cash balance start of month (December):$15,000

Available short-term annual interest rate is 8 percent, long-term debt rate is 9 percent, and long-term equity is 10 percent. All funds would be available the first month when the firm encounters a deficit.

Dividend payment: None

Based on this information, do the following:

Using the Cash Budget spreadsheet, calculate a detailed company cash budget for the forthcoming year. Summarize the sources and uses of cash, and identify the external financing needs for the forthcoming two (2) years.

Cash Budget

Download this Excel spreadsheet to view the company’s cash budget. You will calculate the company’s cash budget for the forthcoming year using this information.

In an executive-level report, summarize the company's financing needs for the forecast period and provide your recommendations for financing the planned activities. Be sure to comment on the following:

a) Your recommended financing solution and cost to the firm: If Genesis needs operating cash, how should it fund this need? Are there internal policy changes with regard to collections or payables management you would recommend? What types of external financing are available?

b) Your concerns associated with the firm's cash budget. Is this a sign of weak sales performance or poor cost control? Why or why not?

Submitted by xoon on Wed, 2014-05-28 14:36
teacher rated 443 times
purchased one time
price: $15.00

100% Perfect A++ Tutorial Guide Assignment 2: Course Project—Genesis Cash Budget Report

body preview (0 words)

file1.docx preview (1485 words)

xxxxxxxxxx 2: LASA x—xxxxxxx xxxx xxxxxx xxxxxx 

Genesis Cash xxxxxxxx

Introduction/about xxx xxxxxxx

xx xx known xxxx now organization xx xxxxx to implement xxxx of xxxxxxxxx xxxxx xxxx xxxx been discussed xx last meeting. xxx expansion xxxxx the first step is to evaluate xxxx position xx organization xxx to understand xxx xxxxxx xx xxxxxxxxx xxxxxx for expansion xxxxxxxxx xxxx xx did not xxxx xxx kind of xxxxxxx in xxxxx of cash position xxx hence xxxxxxxx xxxxxxxxx was not at all needed. xxx when we xxx talking about xxx xxxxxxxxx plans, xx xx important to xxxxxxxxxx cash xxxxxx initially for xxxxxxxxx and xxxx xxxxx xxxx everything xxx been implemented.

xxxx xxxxxxx important factor xx consider would be xxxxxx xx xxxxxxxxx that xxxxxxxxxxxx can look xxxx xxxxx xxx be three types xx xxxxxxxxx that we xxx evaluate:



xxx of xxx two

xxx xxxxxxxxx has to xx reliable xxxxx we are planning for xxxxxxx expansion. xxx financing can xx

- - - more text follows - - -

file2.xlsx preview (195 words)


xxxxxxx xxxx xxxxxx xxxxxx
Monthly xxxxxxxxxxxxxxx Budget
Dec Jan Feb xxxxx xxxxxMayxxxxxxxx Augxxxx OctNovDec xxxxxJune Sept Dec
xxxx Inflow
xxxxx (Reference xxxxxxxxxxxx 200,000 350,000 400,000500,000xxxxxxx700,000 700,000650,000 xxxxxxx 850,000 750,000 xxxxxxxxxxxxxx190,000 3,000,000xxxxxxxxx
Cash xxxxxxxxxxx on xxxxx
xxx in month xx salexxxxxxxxxxxxxxxxxx 40,00050,000 xxxxxx xxxxxx 70,000 65,000 90,00085,000 xxxxxxxxxxxx15,00019,000300,000xxxxxxx
xxx in first xxxxx after xxxx xxxxxx50,000 87,500 xxxxxxx xxxxxxx xxxxxxx175,000175,000xxxxxxx xxxxxxxxxxxxxx187,500 xxxxxxx 44,167xxxxxxxxxxxxxx
xxx xx xxxxxx xxxxx after sale xxxxxxx 70,000122,500140,000xxxxxxx xxxxxxx 245,000245,000 227,500xxxxxxxxxxxxxx455,00057,167 xxxxxxx xxxxxxx
30% xx third month after xxxx 90,000 xxxxxx105,000 120,000150,000 xxxxxxx xxxxxxxxxxxxxx xxxxxxxxxxxxxx xxxxxxxxxxxxx 57,000 xxxxxxx
xxxxx Cash Receipts xxxxxx15,00015,000 xxxxxx 15,000 xxxxxx 15,000xxxxxxxxxxxx 15,000 15,000xxxxxx15,000 xxxxxx45,000xxxxxxxxxxxx
xxxxx xxxx Inflow 45,000 xxxxxxx xxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxx xxxxxxx 665,000722,500 xxxxxxx812,500xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 2,815,000
xxxx xxxxxxxx
xxxxxxxx Purchases xxxxxxxxxx only) xxxxxxx100,000 xxxxxxx200,000 xxxxxxx 275,000xxxxxxxxxxxxxx325,000450,000 xxxxxxx 375,000 250,000 xxxxxxxxxxxx xxxxxxxxx xxxxxxxxx
xxxxxxx xxx xxxxxxxx Purchase xxxxxxx100,000 xxxxxxx200,000 250,000xxxxxxxxxxxxxx xxxxxxx 325,000450,000xxxxxxx xxxxxxx xxxxxxx88,3331,031,667 xxxxxxxxx
100% in xxxxx xxxxx purchase
xxxxx Cash Paymentsxxxxxx xxxxxx52,50060,000 xxxxxx 82,500 105,000 xxxxxxx xxxxxx xxxxxxx 127,500xxxxxxx90,000xxxxxx xxxxxxx xxxxxxx
Other production cost 30% of xxxxxxxx cost xxxx xxxxx after Purchase
Selling and xxxxxxxxx Expense 15,000 xxxxxxxxxxxx20,000 xxxxxx 27,500xxxxxxxxxxxx 32,50045,000xxxxxx 37,500 25,000 xxxxx xxxxxxxxxxxx 120,000
General and Adminstrative expensesxxxxxxxxxxxx 70,00080,000 xxxxxxxxxxxxxxxxxxxxx140,000 xxxxxxx xxxxxxx170,000 xxxxxxx100,000 xxxxxx38,000 600,000 xxxxxxx
xxxxxxxx Paymentxxxxxxxxxxxx
Tax xxxxxxx xxxxxx15,000 xxxxxx15,000 15,000xxxxxx15,00015,000
xxxxxxxx xxxxxxx
Total xxxx Outlfows xxxxxxxxxxxxx 217,500xxxxxxx xxxxxxxxxxxxxx 532,500xxxxxxxxxxxxxx647,500xxxxxxxxxxxxxxxxxxxxx xxxxxxx177,3332,106,167xxxxxxxxx
Net Cash Gain/(Loss)xxxxxxxxxxxxxxx -25,000xxxxxxxxxxxxxx-15,000 -42,50047,500 xxxxxxxxxxxxx xxxxxx117,500 xxxxxxx33,000xxxxxxxxxxxxxxx
xxxx Flow xxxxxxx
xxxx xxxxxxx start xx the monthxxxxxx xxxxxxxxxxxx xxxxxx25,000 25,000 xxxxxxxxxxxxxxxxxx 147,500 xxxxxx 170,000 xxxxxxxxxxxxxxxx1,298,000504,000
xxx Cash xxxxxxxxxxxxxxxxx -12,500xxxxxxx -52,500-22,500-15,000 xxxxxxx xxxxxx75,000xxxxxxx xxxxxx xxxxxxx 977,500 33,000 xxxxxxxxxxxxxxx
Cash Balance xx end xx month xxxxxxxx12,500 xxxxxxxx 2,50010,000 xxxxxxx 72,500xxxxxxxxxxxxx170,000xxxxxxx1,265,0001,298,000 504,000xxxxxxx
Minium xxxx Balance xxxxxxxxxxxxxxxxxxx 25,000 xxxxxxxxxxxx25,000xxxxxx 25,000 xxxxxxxxxxxx 25,000 xxxxxxxxxxxxxxxxxxxxxxxx25,000
xxxxxxx cash xxxxxxxxxxxxxxxxx-12,500-25,000 -52,500-22,500 -15,000 xxxxxxxxxxxxx122,500 72,500145,000 262,500xxxxxxxxx1,273,000 479,000xxxxxxx
xxxxxxxx xxxxxxxxx Summary
External Financing Balancex xxxxxxx157,500 182,500 xxxxxxx257,500xxxxxxx xxxxxxx 315,000315,000 xxxxxxx xxxxxxx xxxxxxx xxxxxxxxxxxxxx315,000
at start xx month
New xxxxxxxxx Requiredxxxxxxxx -12,500 xxxxxxx-52,500 -22,500-15,000 -42,500 0 x 00 xx0xx
xxxxxxxxx amount xxxx xxxx
suplus xxxxxxxxx
xxxxxxxx xxxxxxxxx xxxxxxxxxxx 145,000xxxxxx 25,000xxxxxxxxxxxx 15,00042,500 x x xx 0 x x 0 0
External xxxxxxxxx xxxxxxx xxxxxxx xxxxxxx xxxxxxx235,000 257,500272,500 315,000xxxxxxx315,000315,000xxxxxxx xxxxxxx315,000 315,000315,000xxxxxxx



Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Submitted by RSaleem on Mon, 2014-06-02 06:38
teacher rated 179 times
price: $25.00

A+ Solution - Reliable - Perfect with APA format Fomratting - All Points Covered and Already Graded 5 / 5 - A Solution you can Trust

body preview (0 words)

file1.docx preview (1486 words)

xxxxxxx Cash Position






Genesis Cash xxxxxxxx

xxxxxxxxxxxxxxxxxx xxx company

xx xx xxxxx that now xxxxxxxxxxxx is going xx xxxxxxxxx some xx xxxxxxxxx plans xxxx xxxx xxxx xxxxxxxxx in last xxxxxxxx xxx xxxxxxxxx plan, the xxxxx xxxx is xx evaluate cash position of xxxxxxxxxxxx and xx understand xxx xxxxxx of xxxxxxxxx needed for expansion plan.Till xxxx we did not have any xxxx of xxxxxxx in terms xx cash xxxxxxxx and xxxxx xxxxxxxx xxxxxxxxx xxx not xx all xxxxxxx xxx when we are talking about xxx xxxxxxxxx plans, it is xxxxxxxxx xx understand cash xxxxxx initially xxx expansion and cash xxxxx xxxx xxxxxxxxxx has been implemented.

xxxx another xxxxxxxxx xxxxxx xx xxxxxxxx xxxxx be source of financing that organization can xxxx xxxx xxxxx can be three types of xxxxxxxxx xxxx we can evaluate:



Mix of the two

xxx xxxxxxxxx has xx xx reliable since xx are xxxxxxxx for xxxxxxx expansion. xxx financing can be xxxx with for

- - - more text follows - - -

file2.xlsx preview (195 words)


xxxxxxx Cash Budget ($000)
Monthly xxxxxx xxxxxxxxx xxxxxx
xxxxxx xxxxxxxx xxxxx MayJune xxxx xxx Septxxx xxx Dec xxxxx xxxxxxxxDec
xxxx Inflow
Sales (Reference only)xxxxxxxxxxxxxx xxxxxxxxxxxxxx500,000550,000xxxxxxxxxxxxxxxxxxxxx xxxxxxx xxxxxxxxxxxxxx 500,000150,000190,0003,000,0002,400,000
Cash Collections on Sales
10% xx month xx xxxx xxxxxxxxxxxx 35,000xxxxxx50,000 55,000xxxxxx70,000 65,000xxxxxx 85,000xxxxxx xxxxxx xxxxxx xxxxxx300,000240,000
xxx in xxxxx xxxxx after xxxxxxxxxx50,000 xxxxxx xxxxxxxxxxxxxx xxxxxxxxxxxxxx 175,000162,500xxxxxxxxxxxxxx xxxxxxx150,000 44,167515,833650,000
xxx xx second xxxxx xxxxx xxxxxxxxxxx xxxxxxxxxxxxx140,000xxxxxxx192,500245,000245,000 xxxxxxx 315,000xxxxxxx xxxxxxx57,167xxxxxxx980,000
xxx in xxxxx month xxxxx xxxx 90,000 60,000xxxxxxx120,000 xxxxxxx 165,000 210,000xxxxxxxxxxxxxx xxxxxxx 630,000 xxxxxx xxxxxx xxxxxxx
Other xxxx Receipts xxxxxx xxxxxx xxxxxx xxxxxx15,000xxxxxxxxxxxx15,000xxxxxx xxxxxx 15,00015,000 xxxxxx 45,000xxxxxxxxxxxxxxxxxx
xxxxx xxxx xxxxxx 45,000 110,000 205,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxx 602,500665,000 722,500xxxxxxxxxxxxxx820,000 xxxxxxxxx 210,333xxxxxxxxx2,815,000
xxxx Outflows
Material xxxxxxxxx xxxxxxxxxx only)150,000xxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxx xxxxxxx xxxxxxx 325,000 450,000 xxxxxxx 375,000xxxxxxx 75,00095,000 1,500,000 xxxxxxxxx
xxxxxxx xxx xxxxxxxx xxxxxxxx xxxxxxx 100,000 175,000 200,000 250,000 xxxxxxx 350,000xxxxxxxxxxxxxxxxxxxxx xxxxxxx375,000 xxxxxxx 88,333 1,031,667xxxxxxxxx
100% xx month after xxxxxxxx
xxxxx Cash Payments xxxxxx30,000 52,50060,000 75,000 82,500105,000xxxxxxx 97,500135,000 xxxxxxxxxxxxxxxxxxxxxxxxxx309,500 xxxxxxx
Other production cost 30% of Material cost paid month xxxxx xxxxxxxx
xxxxxxx xxx Marketing xxxxxxxxxxxxx 10,000 17,500 xxxxxx25,000 27,50035,000xxxxxx 32,500xxxxxx42,50037,500xxxxxx7,500 xxxxx xxxxxxx 120,000
xxxxxxx and Adminstrative expenses xxxxxx40,000 70,000 xxxxxxxxxxxxx110,000 140,000140,000 130,000xxxxxxxxxxxxxxxxxxxxx 100,000xxxxxx38,000 600,000480,000
Interest Payment 75,000 xxxxxx
Tax xxxxxxx 15,000 15,000 15,00015,000xxxxxx15,000 xxxxxx 15,000
xxxxxxxx Payment
xxxxx xxxx xxxxxxxx 75,000245,000xxxxxxxxxxxxxxxxxxxxx462,500 xxxxxxx645,000xxxxxxx 647,500xxxxxxx740,000 702,500 xxxxxxx 177,333xxxxxxxxx 2,380,000
Net xxxx xxxxxxxxxxxxxxxxxxx xxxxxxx-25,000xxxxxxxxxxxxxx xxxxxxx-42,500 47,500 xxxxxxxxxxxxxxxxxxx117,500977,500xxxxxx -794,000 435,000
xxxx xxxx xxxxxxx
xxxx Balance start of xxx xxxxx15,000 25,000 25,00025,000xxxxxx25,000 25,00025,000 72,500 xxxxxxx 97,500xxxxxxx287,500 xxxxxxxxx xxxxxxxxx504,000
Net xxxx Gain/loss -135,000 -12,500 -25,000 xxxxxxx xxxxxxxxxxxxxx-42,500 47,500 xxxxxx-50,000xxxxxx117,500977,500 33,000xxxxxxxx xxxxxxx
xxxx Balance xx xxx of month -120,00012,500 0 -27,500 2,500 10,000xxxxxxx xxxxxx xxxxxxx xxxxxx xxxxxxx 287,500 xxxxxxxxx xxxxxxxxx xxxxxxx 939,000
Minium cash Balance desiredxxxxxxxxxxxx25,000xxxxxx 25,000 xxxxxx25,000xxxxxx 25,000xxxxxx xxxxxx xxxxxx25,00025,00025,000 xxxxxx
xxxxxxx cash (deficit)-145,000 -12,500-25,000-52,500 xxxxxxxxxxxxxx-42,500 47,500 xxxxxxx72,500 xxxxxxx xxxxxxx 1,240,000 1,273,000 xxxxxxxxxxxxxx
xxxxxxxx xxxxxxxxx xxxxxxx
xxxxxxxx xxxxxxxxx Balance0 145,000157,500 xxxxxxx 235,000 257,500 272,500 xxxxxxxxxxxxxx xxxxxxx xxxxxxxxxxxxxx xxxxxxx xxxxxxx xxxxxxx xxxxxxx
at start xx xxxxx
xxx Financing Required-145,000 xxxxxxx -25,000 xxxxxxx -22,500 xxxxxxxxxxxxxx0x x00x 0 0 0
xxxxxxxxx amount xxxx xxxx
suplus xxxxxxxxx
xxxxxxxx Financing Requirement 145,00012,50025,000 xxxxxx 22,500 15,00042,500 0 xxxx x 0x0
External Financing xxxxxxx xxxxxxx xxxxxxxxxxxxxxxxxxxxx257,500272,500 315,000 xxxxxxx xxxxxxx xxxxxxxxxxxxxx315,000xxxxxxx xxxxxxxxxxxxxx 315,000



Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Submitted by SolutionGuru on Mon, 2013-10-21 09:23
teacher rated 95 times
purchased 4 times
price: $35.00

Assignment 2: LASA 1—Genesis Cash Budget Report in Details (8 Pages)__GOOD QUALITY & DEPTH ANALYSIS__ANSWERS YOU CAN TRUST !!!!!!!

body preview (16 words)

xxxxxxxxxx 2: xxxx xxxxxxxxxxx xxxx xxxxxx xxxxxx xx xxxxxxx (8 xxxxxxxxxxxx xxxxxxx & xxxxx xxxxxxxxxxxxxxxxx YOU xxx TRUST !!!!!!!

file1.doc preview (2015 words)

xxxxxxxxx Summary

xxxx xx xxx important xxxxxxx xxxxx xxx xxx operations of xxx business. xxxx planning is a technique to plan xxx control xxx use of cash. The xxxxxxx xxxx is xxxxx xx xx Genesis Corporation through a critical xxxxxxxxx xxxx new overseas xxxxxxxx The xxxx’x xxxx position xxx xxx pose any challenge previously. xxx firm xxxx be prepared to implement xxx xxxxxxxxx expansion plan through identifying reliable source xx funds for xxxx xxxxxxxxxx xxx xxxxxxxxx xxxxxx

xxxx xxxxxx xx the xxxx significant xxxxxx xx xxxx xxx and xxxxxxx xxxx xxxxxxxx and xxxxxxxxxx cash budget xx x xxxxxxx statement xx xxx xxxx’s xxxxxxxx xxxx inflows and outflows xxxx a xxxxxxxxx time period. Cash xxxxxxxxx are xxxxxx to xxxxxxx xxxx budgets. A xxxxxxx cash xxxxxx for xxx current xxxx and a xxxxxxxxx xxxxxx xxx the subsequent xxxxxxxxxxxx xxx xxxxxxxxx xx xxxx xxxxxx paper. xxxxxxxxxx xxxxxxxxxx xxxxx xxxxxxxx trends of xxxxxx cash xxxxxxxx xxx xxxx xxxxxxxx some xxxxxxxxx xxxxxxxxxxxxxx

- - - more text follows - - -

file2.xls preview (412 words)

Cash xxxxxx & xxxxxxxxx

Genesis Cash xxxxxx ($000) xxxxxxx xxxxxx Quarterly Budget
xxxx xxxxxx Octxxx Decxxxxxx March xxxxxMayJune Julyxxx xxxxxxxxxxxxx March June Sept xxx
xxxxx (Reference xxxxx xxxxxxx300,000300,000 200,000xxxxxxx xxxxxxx xxxxxxx 550,000 700,000 xxxxxxx650,000xxxxxxx850,000xxxxxxx500,000150,000190,000 xxxxxxx 240,000
xxxx Collections on xxxxx
xxx in month of xxxx 30,000 30,00030,000 xxxxxx35,000xxxxxxxxxxxxxxxxxx xxxxxx xxxxxx65,000xxxxxx xxxxxx75,00050,000xxxxxx 19,000 xxxxxx 24,000
25% xx first xxxxx after sale75,000 75,000 xxxxxx50,000xxxxxx100,000xxxxxxxxxxxxxxxxxxxxx 175,000 162,500xxxxxxxxxxxxxx 187,500125,00037,500 xxxxxxxxxxxx
xxx in second month xxxxx sale xxxxxxx 105,000 105,000 70,000 122,500140,000 xxxxxxx xxxxxxx xxxxxxx xxxxxxx 227,500 315,000297,500 xxxxxxx 175,000 xxxxxxxxxxxx
xxx xx third month after xxxx 90,000 90,000xxxxxx xxxxxx 105,000 120,000150,000 xxxxxxx xxxxxxx 210,000 xxxxxxx xxxxxxx255,000xxxxxxx xxxxxxxxxxxxx
xxxxx xxxx Receipts 15,000xxxxxxxxxxxx 15,00015,000 15,000 15,00015,000 xxxxxx xxxxxxxxxxxxxxxxxx15,000xxxxxx15,00015,000xxxxxx 15,000 15,000
xxxxx Cash xxxxxx xxxxxxxxxxxxxx xxxxxxx 347,500xxxxxxx xxxxxxxxxxxxxx665,000xxxxxxxxxxxxxx xxxxxxx 820,000xxxxxxx 471,500 xxxxxxx xxxxxxx
Cash xxxxxxxx
Material xxxxxxxxx xxxxxxxxxx only) 150,000150,000 150,000100,000 xxxxxxx xxxxxxx250,000275,000350,000350,000 xxxxxxx450,000425,000375,000 xxxxxxx 75,00095,000150,000xxxxxxx
xxxxxxx for Material xxxxxxxx
xxxx in xxxxx after xxxxxxxx 150,000xxxxxxx xxxxxxxxxxxxxxxxxxxxx200,000 250,000 275,000350,000350,000 xxxxxxxxxxxxxx xxxxxxx xxxxxxx 250,000xxxxxx95,000xxxxxxx
xxxxx xxxxxxxxxx xxxx 30% of Material xxxx xxxx month xxxxx xxxxxxxx xxxxxx xxxxxxxxxxxx 30,00052,500 xxxxxxxxxxxx82,500xxxxxxx 105,000 xxxxxxxxxxxxx xxxxxxx xxxxxxx75,00022,500xxxxxxxxxxxx
Selling xxx Marketing

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Submitted by shahimermaid on Wed, 2012-02-29 07:46
teacher rated 377 times
purchased 50 times
price: $30.00

Answer rating (rated 5 times)


the answer is in excel file, and there is a 2 page write up that explains the excel sheet.

body preview (47 words)

xxxxx xxx 2 excel xxxxx The xxxx with original data xxx sales figures as given in question for quarterly budget as xxxxxxx xxxx xxxxxxxx vague xx I have xxxxx 1 xxxx xxxx xxx solved. it. xxx write xx xx to help you xxxxxxxxxx xxx xxxxxxx used xx xxxxx sheet.

file1.xlsx preview (402 words)


xxxxxxx xxxx xxxxxx xxxxxx
xxx Janxxx xxxxx AprilMayJuneJulyxxxSept OctNovxxxMarch xxxxSept Dec March
xxxx xxxxxx
Opening Balance
xxxxx xxxxxxxxxx xxxxx300,000 xxxxxxxxxxxxxxxxxxxxx 500,000 xxxxxxx 700,000 700,000xxxxxxx xxxxxxxxxxxxxx750,000xxxxxxxxxxxxxxxxxxxxxxxxx3,000,000xxxxxxxxx
xxxx xxxxxxxxxxx xx Sales
xxx in month of xxxxxxxxxx 40,00070,000xxxxxx100,000xxxxxxx xxxxxxx xxxxxxx xxxxxxx180,000 170,000 150,000 xxxxxxxxxxxxxx 380,000xxxxxxxxxxxxxx
xxx in first xxxxx after sale xxxxxx 60,000105,000120,000xxxxxxxxxxxxxx xxxxxxx 210,000195,000 xxxxxxx255,000xxxxxxxxxxxxxxxxxxxxx xxxxxxx 720000
xxx xx second xxxxx after xxxx 105,000 xxxxxx 122,500 140,000175,000xxxxxxxxxxxxxx245,000 227,500315,000 xxxxxxx xxxxxxxxxxxxxx 1050000 xxxxxx
40% xx xxxxx month after xxxx 120,00080,000xxxxxxxxxxxxxx 200,000 xxxxxxx 280,000xxxxxxxxxxxxxx360,000xxxxxxx760000
xxxxx Case Receipts 15,000 15,000xxxxxx 15,00015,000 xxxxxxxxxxxxxxxxxx 15,000 xxxxxxxxxxxx xxxxxx xxxxxx 45,00045,000xxxxxxxxxxxx
Total Cash Inflowxxxxxx145,000250,000390,000437,500xxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx 962,500 xxxxxxx xxxxxxx 345,000 xxxxxxx xxxxxxxxx2,690,000
xxxx Outflows
Material Purchases xxxxxxxxxx xxxxx xxxxxxx xxxxxxxxxxxxxx 200,000 xxxxxxx275,000xxxxxxx350,000 325,000450,000xxxxxxx375,000 250,000 750,000 xxxxxxx1,500,0001,200,000
Payment xxx Material xxxxxxxx
100% xx xxxxx xxxxx xxxxxxxxxxxxxxxxxxxxxx175,000200,000 xxxxxxx 275,000xxxxxxx xxxxxxx xxxxxxxxxxxxxx425,000 375,000xxxxxxx xxxxxxx950,000xxxxxxxxxxxxxxxxxx
xxxxx xxxx Payments
xxxxx xxxxxxxxxx cost 30%xxxxxx 30,000 52,500 xxxxxx75,000 xxxxxx 105,000xxxxxxxxxxxxx135,000127,500xxxxxxxxxxxxxx xxxxxxxxxxxxxx360000
of xxxxxxxx xxxx paid xxxxx
xxxxx xxxxxxxx
xxxxxxx xxx xxxxxxxxx

- - - more text follows - - -

file2.xlsx preview (400 words)


Genesis Cash Budget xxxxxx
Dec xxx xxxMarchApril Mayxxxx xxxxxxxSeptOctNovDecMarch June Sept Decxxxxx
xxxx xxxxxx
xxxxxxx xxxxxxx
Sales xxxxxxxxxx only) 300,000 xxxxxxx xxxxxxx xxxxxxx xxxxxxxxxxxxxx 700,000700,000650,000 xxxxxxx850,000 750,000500,000150,000190,000 xxxxxxxxxxxxxxxxxx
xxxx xxxxxxxxxxx xx xxxxx
xxx xx xxxxx xx salexxxxxxxxxxxx 70,000 xxxxxx xxxxxxx110,000xxxxxxx 140,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx xxxxxx38,000600,000xxxxxxx
30% in first xxxxx after sale xxxxxx60,000xxxxxxx xxxxxxx150,000165,000210,000 xxxxxxx 195,000 270,000 255,000 xxxxxxx xxxxxxxxxxxx 900,000xxxxxx
xxx in second month after sale xxxxxxx70,000xxxxxxx140,000 xxxxxxx xxxxxxx xxxxxxx xxxxxxx xxxxxxxxxxxxxx 297,500xxxxxx66,500xxxxxxx840000
xxx xx xxxxx xxxxx xxxxx salexxxxxxx80,000 xxxxxxx160,000xxxxxxx 220,000 xxxxxxx xxxxxxx 260,000 xxxxxxxxxxxxx 76000
xxxxx Case Receiptsxxxxxx15,000 15,000xxxxxx 15,000xxxxxxxxxxxx15,000xxxxxx15,000 15,00015,000xxxxxx xxxxxx xxxxxx45,000 xxxxxx
xxxxx Cash Inflow 75,000 145,000250,000xxxxxxx 437,500555,000xxxxxxx 757,500820,000915,000962,500xxxxxxxxxxxxxx xxxxxx128,000 xxxxxxxxxxxxxxxx
Cash xxxxxxxx
Material xxxxxxxxx (reference xxxxxxxxxxxx 100,000xxxxxxx xxxxxxx xxxxxxxxxxxxxx 350,000 xxxxxxx xxxxxxx xxxxxxxxxxxxxx xxxxxxx xxxxxxx 75,000xxxxxxxxxxxxxxx 1,200,000
Payment for xxxxxxxx xxxxxxxx
100% xx xxxxx xxxxx purchase 150,000 xxxxxxx175,000200,000 250,000xxxxxxxxxxxxxx 350,000xxxxxxxxxxxxxx xxxxxxxxxxxxxx xxxxxx 95,000xxxxxxxxx xxxxxxxxx
xxxxx xxxx xxxxxxxx
Other production xxxx xxx45,000xxxxxxxxxxxx xxxxxxxxxxxx82,500xxxxxxxxxxxxxx xxxxxx 135,000xxxxxxx xxxxxxx 22,500 xxxxxx xxxxxxx xxxxxx
xx Material xxxx xxxx xxxxx
after xxxxxxxx
xxxxxxx and Marketing Expense 15,000 10,000 xxxxxx xxxxxxxxxxxxxxxxxx 35,000 xxxxxx xxxxxx45,00042,500 37,500xxxxxx 7,500 9,500150,000xxxxxxx
xxxxxxx xxx

- - - more text follows - - -

file3.docx preview (1109 words)

Genesis is trying to make xxx cash xxxxxx for future x xxxxxx xxx first xxxx budget is prepared on xxxxxxx xxxxx and the xxxxxx one is prepared xx quarterly xxxxxx xx the xxxxxxx xxxxxx xx xxxx xxx cash xxxxxx for December, we do xxx know xxx details about xxxxxxxx xxxxxxx therefore xxx xxxx inflow is very less. xx xxxxxxx x recommend xxxx the company borrow x 2, 50,000 at xx for one xxxxx The company will xxxxxx comfortable xxx xxxxxxx xx xxxxxxxxx xxxxx xxxx xxx xxxx xxxxxx the xxxxxxx xxxx xxxx xxxx cost also.

There were xxxxx option: xx xxxxxx xxxxxxxxx xxxxxxx or xxxxxxxxx Borrowing x xxxx xxxx xxxx company xxxxxx xxxx xxxxx and xx xxx company borrows x xxxxx xxxxx xxxx xxxxxx xx xxxxxx cash. So xxxxxxxxx 2.50 lakh xxxxx the xxxxxxx adequate xx xxxx xx xxx xxxxxxx

xx the xxxxx of December xxxx xxxxxx xx 75,000 and xxxxxxx is 3,00,000. xxxxx is a xxxxxxxxx of 2,25,000. As the cash balance in the beginning of December xxx 15,000, xxxxx is a xxxxxxxxx xx xxxxxxxxxx xx is desired,

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Submitted by humblejeff on Wed, 2012-02-29 07:46
teacher rated 31 times
purchased 5 times
price: $50.00

Answer rating (rated 3 times)


the answer is given below

body preview (4 words)

xxx answer xx xxxxxxxx

file1.xlsx preview (313 words)


Genesis xxxx Budget xxxxxx
DecxxxFebxxxxx AprilMayJune xxxxxxxxxxx xxxNov xxxMarch xxxx xxxx xxx
Cash Inflow
xxxxx (Reference xxxxx300,000 200,000350,000 400,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxx650,000xxxxxxx xxxxxxx750,000xxxxxxx 150,000xxxxxxx xxxxxxxxx 2,400,000
xxxx xxxxxxxxxxx xx Sales
xxx in month of xxxx xxxxxxxxxxxx70,000 xxxxxx 100,000 xxxxxxxxxxxxxxxxxxxxx130,000180,000 xxxxxxx 150,000xxxxxxxxxxxxx 38,000xxxxxxxxxxxxxx
xxx in xxxxx month after xxxx90,000xxxxxx105,000120,000xxxxxxx 165,000 210,000 210,000 195,000 270,000 255,000 xxxxxxxxxxxxxx45,000 xxxxxx 900,000xxxxxxx
xxx xx second xxxxx xxxxx sale xxxxxxx70,000 xxxxxxx140,000 xxxxxxx192,500 245,000 xxxxxxx 227,500 xxxxxxx 297,500xxxxxxx xxxxxxxxxxxxxx66,500xxxxxxxxx xxxxxxx
40% in xxxxx xxxxx after xxxx xxxxxxx80,000140,000 xxxxxxx 200,000 xxxxxxx 280,000xxxxxxx260,000 xxxxxxx xxxxxxxxxxxxxx200,000 xxxxxx76,000 xxxxxxxxxxxxxxxx
xxxxx Case xxxxxxxxxxxxxxxxxxxx 15,00015,000 xxxxxx15,000xxxxxx xxxxxx15,000xxxxxxxxxxxx 15,000 15,000xxxxxxxxxxxx 150,000150,000
xxxxx xxxx xxxxxxxxxxxxx265,000 452,500 515,000640,000702,500 xxxxxxx890,000827,500 1,140,000 xxxxxxxxx 952,500 xxxxxxx675,000xxxxxxx xxxxxxxxx xxxxxxxxx
Cash xxxxxxxx
xxxxxxxx Purchases xxxxxxxxxx only)
xxxxxxx for xxxxxxxx xxxxxxxx1,500,000 100,000 175,000xxxxxxx 250,000xxxxxxx 350,000xxxxxxx 325,000xxxxxxx 425,000 375,000xxxxxxx xxxxxxxxxxxx 1,500,000 1,200,000
100% in month xxxxx xxxxxxxx
Other Cash xxxxxxxx
xxxxx xxxxxxxxxx xxxx 30%90,000 60,000 xxxxxxxxxxxxxx xxxxxxxxxxxxxx210,000210,000195,000270,000255,000225,000 xxxxxxx 45,000xxxxxx900,000 xxxxxxx
of xxxxxxxx cost paid xxxxx
after xxxxxxxx
Selling xxx

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Submitted by neel on Mon, 2012-07-16 14:37
teacher rated 523 times
purchased 6 times
price: $23.00

Answer rating (rated one time)


Answer-100% correct solution

body preview (4 words)


xxxx x xxxxxxxxxxxxxxxxx

file1.xlsx preview (403 words)


Genesis Cash Budget xxxxxx
xxxxxxFebxxxxxxxxxx MayJune July Aug Sept xxxxxxxxxxxxxxJune xxxxDec
Cash xxxxxx
xxxxx (Reference xxxxx 300,000200,000350,000xxxxxxx xxxxxxx 550,000700,000700,000xxxxxxx 900,000 xxxxxxx750,000 xxxxxxx150,000 190,000xxxxxxxxx2,400,000
Cash xxxxxxxxxxx xx Sales
xxx in xxxxx xx sale30,000 20,000 35,000 xxxxxx50,000 55,000 70,00070,000xxxxxx90,00085,00075,000 xxxxxx
xxx in xxxxx xxxxx xxxxx xxxx xxxxxx 50,000 87,500 100,000 125,000 137,500 xxxxxxx xxxxxxx 162,500 225,000 xxxxxxxxxxxxxx
35% in xxxxxx month after sale 105,00070,000 xxxxxxx xxxxxxxxxxxxxxxxxxxxx xxxxxxx245,000227,500315,000 297,500
30% in third month xxxxx sale90,000 xxxxxxxxxxxxxxxxxxxx 150,000 165,000 xxxxxxx xxxxxxx xxxxxxx270,000
xxxxx xxxx xxxxxxxxxxxxxx15,000 xxxxxx xxxxxx 15,000 15,00015,00015,000xxxxxx 15,00015,000 15,000
xxxxx xxxx Inflow30,000xxxxxxx xxxxxxxxxxxxxxxxxxxxx 440,000 xxxxxxx602,500665,000 xxxxxxx 762,500812,500xxxxxxx
xxxx xxxxxxxx
xxxxxxxx Purchases (reference xxxxx xxxxxxx xxxxxxx 175,000200,000 xxxxxxxxxxxxxx xxxxxxx 350,000 325,000450,000425,000xxxxxxx250,000
xxxxxxx xxx xxxxxxxx Purchase
xxxx xx xxxxx xxxxx xxxxxxxx 150,000 100,000 xxxxxxx xxxxxxxxxxxxxx 275,000 xxxxxxxxxxxxxx xxxxxxx xxxxxxx 425,000375,000
xxxxx xxxx xxxxxxxx
xxxxx xxxxxxxxxx cost xxxxxxxxx30,000xxxxxx xxxxxx xxxxxx xxxxxxxxxxxxx 105,00097,500xxxxxxx127,500 xxxxxxx
xx Material xxxx paid month
after xxxxxxxx
Selling xxx Marketing xxxxxxx15,000 xxxxxx17,500 xxxxxx 25,00027,500 xxxxxx 35,000 32,500 xxxxxxxxxxxx 37,50025,000
General xxx xxxxxxxxxxxxx

- - - more text follows - - -

Buy this answer

Try it before you buy it
Check plagiarism for $2.00