Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Monthly pro forma template

25/04/2021 Client: muhammad11 Deadline: 2 Day

Cash Budget Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 Credit sales account for 70% of the monthy sales and are collected one month after the sale. Other receipts for October are $50,000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Blue Bill Corporation Cash Budget Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fixed disbursements Other disbursements Total cash disbursements June $200,000 60,000 - July $200,000 60,000 140,000 August September $200,000 $300,000 60,000 90,000 140,000 140,000 60,000 200,000 200,000 230,000 120,000 10,000 120,000 10,000 180,000 10,000 130,000 130,000 120,000 10,000 80,000 210,000 190,000 Net change during the month (70,000) 70,000 (10,000) 40,000 Beginning cash Ending cash Required cash Excess cash to invest Cash borrowed 50,000 (20,000) 10,000 (20,000) 50,000 10,000 40,000 50,000 40,000 10,000 30,000 40,000 80,000 10,000 70,000 30,000 hrough November: after the sale. ough November. October November $500,000 $200,000 These amounts were given 150,000 60,000 The cash sales are 30% of monthly sales because they tell us that credit sa 210,000 350,000 Leave the collections amount blank for June. Collections are credit sales. T 50,000 They tell us Other Receipts for October are $50,000. No other receipts for t 410,000 410,000 Add the totals of cash sales, collections, and other receipts. Do not include 300,000 10,000 310,000 100,000 80,000 180,000 10,000 170,000 120,000 10,000 400,000 530,000 They tell us Variable disbursements are 60% of sales each month They tell us Fixed disbursements are $10,000 each month They paid $80,000 in taxes for August and $400,000 debt repayment in No Add all of the disbursements (120,000) Subtract the Total Cash Disbursements from the Total Cash Receipts 180,000 60,000 10,000 50,000 Beginning cash in June is $50,000. Then use the Ending Cash amount as th Net change during the month amount plus Beginning Cash They tell us Desired Cash is $10,000 so use this amount for each month Ending Cash minus Required Cash Cash borrowed would be negative B42 plus B43 for June only. Leave the o ons are credit sales. They tell us that Credit Sales(Collections) are 70% of monthly sales starting in July. For C y sales starting in July. For Collections you do not start collecting until after the first month so the first $140,0 irst month so the first $140,000 would not be until July. So leave the Collections amount for June blank. Then amount for June blank. Then you would take 70% of Sales from the previous month for each Collection amoun th for each Collection amount. For instance, your Collection amount for September would be $140,000 which i r would be $140,000 which is 70% of the $200,000 Sales amount for August. Then for the collection amount f en for the collection amount for October would be $210,000 which is 70% of the Sales amount from Septembe Sales amount from September. And so on..... Pro Forma Income Statement and Balance Sheet Below is the income statement and balance sheet for Blue Bill Corporation for 2013. Based on the historical sta additional information provided, construct the firm's pro forma income statement and balance sheet for 2014. Blue Bill Corporation Income Statement For the year ended 2013 Revenue Cost of goods sold Gross margin SG&A expense Depreciation expense Earnings Before Interest and Taxes (EBIT) Interest expense Taxable income Income Tax Expense Net income Dividends To retained earnings 2012 $60.000 42.000 18.000 6.000 1.800 10.200 1.500 8.700 3.045 5.655 750 $4.905 2013 $63.000 44.100 18.900 6.300 2.000 10.600 1.800 8.800 3.080 5.720 800 $4.920 Projected 2014 Additional income statement information: Sales will increase by 5% in 2014 from 2013 levels. COGS and SG&A will be the average percent of sales for the last 2 years. Depreciation expense will increase to $2,200. Interest expense will be $1,900. The tax rate is 35%. Dividend payout will increase to $850. Blue Bill Corporation Balance Sheet December 31, 2013 2013 Current assets Cash Accounts receivable Inventory Total current assets Property, plant, and equipment (PP&E) Accumulated depreciation Net PP&E Total assets Current liabilites Accounts payable $8.000 3.150 9.450 20.600 28.500 16.400 12.100 $32.700 $3.780 Projected 2014 Bank loan (10%) Other current liabilities Total current liabilities Long-term debt (12%) Common stock Retained earnings Total liabilities and equity 3.200 1.250 8.230 4.800 1.250 18.420 $32.700 Additional balance sheet information: The minimum cash balance is 12% of sales. Working capital accounts (accounts receivable, accounts payable, and inventory) will be the same percent of s $8,350 of new PP&E will be purchased in 2014.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Assignment Hub
Academic Master
Coursework Helper
Top Academic Tutor
Top Class Results
Best Coursework Help
Writer Writer Name Offer Chat
Assignment Hub

ONLINE

Assignment Hub

I have read and understood all your initial requirements, and I am very professional in this task.

$17 Chat With Writer
Academic Master

ONLINE

Academic Master

I will cover all the points which you have mentioned in your project details.

$46 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

I will cover all the points which you have mentioned in your project details.

$48 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I will cover all the points which you have mentioned in your project details.

$41 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$50 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I have read and understood all your initial requirements, and I am very professional in this task.

$34 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Excel module 1 creating a worksheet and a chart - Item Response - Redefining global strategy summary - Linear regression in stock market - Example of autobiography of students - Difference between psychological egoism and ethical egoism - Hp j4813a procurve switch 2524 firmware download - Tennis court fencing specifications - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - Iinet voip call forwarding - Rate of change - Anova worksheet - Hive single channel receiver - Oedipus rex short version - Sonny's blues short story summary - Walt disney company case study - CIS 348 Assignment 1: Privacy, Laws, and Security Measures - Fail Companies - Decrypt pgp file command line - Audience analyse - An asset turnover ratio of 1.75 can be interpreted as - The company's adjusted trial balance as follows - Denso under bunk air conditioner - Outliers the roseto mystery - Questions to answer - Where to buy japanese kitkat online - From the list of java variable names below, select the illegal variable name. - Scarcity occurs because of eco 365 - How to write a recommendation report for a company - Good to great chapter 3 - Ratios and financial planning at east coast yachts solution - Peggy hettrick defense - Best linear unbiased estimator ppt - Essay - Kitty lee dance company - Nursing - Assignment: Examine Effective Communication Channels Between Leaders and Personnel - Discussion question - Chapter 8 web server hardware and software - Unit 5 db pm deliver in 12hrs - Week 8 - Toffler's three business ethics principles - Walt disney company target market - Picot question for reducing hospital readmissions - Contemporary nursing practice - Doppler effect experiment classroom - Single phase semi controlled rectifier - 5 major world religions quiz - 5 steps of the writing process - Paper on Big Data and Internet of Things - 2 5 journal importance of analysis - Uel accounting and finance - Nurse practitioner core competencies 2016 - Nurs495 prompt w6 - Milton when i consider - What is integrity interview question - How to request an extension on webassign - Any old bag speech ideas - Maquilapolis film analysis - Unit 7 Assignment (SOC101) - Walmart Manages Ethics and Compliance Challenges - Christiansen 1977 twin study - Montgomery Bus Boycott - Chapter 6 time value of money - Answer to essay-200 words minimum (mgc) - Cover letter for vacation work - Read vs readlines python - Wrtg 393 white paper - Extraction of caffeine from tea lab report - Hera's rebellion against zeus - Time and the monuments eugene berman - Wk 2 Discussion – Communication in Project Management [due Thurs] - Bronglais hospital ward map - Www plagiarism org plag_article_citation_styles html - Force field minecraft hack - Why does othello start in the middle of a conversation - Module 1 cells as the basis of life answers - Abn 19 619 574 186 - 173.33 hours per month - Differentiation of inverse hyperbolic functions examples - Harley mission statement - Cognition 5th edition smilek ebook - The raven himself is hoarse - Bratt pan safety procedures - What is the compensation philosophy of maersk - According to prothero what is the problem for judaism - Isolated high side gate driver - Beech corporation an accrual basis taxpayer - Jim webster pavilion claremont showgrounds - Resultant force bbc bitesize - Phonetic symbols for the words quay and queue - How to determine the net present value - Addressing floating and patient safety - Tommy memphis gig guide - Family health assessment part 2 - Malapropism much ado about nothing - Kite runner chapter 13 summary - Ford finance interview case study - Instituting policies and procedures that facilitate good strategy implementation and execution - Have to answer this two questions with in one hour