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

Problem#15

15/08/2020 Client: lyjly0 Deadline: 10 Days

 


Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:


Sales


Labor and Raw Materials


May, 2020


$75,000


$80,000


June, 2020


$115,000


$75,000


July, 2020


$145,000


$105,000


August, 2020


$125,000


$85,000


September, 2020


$120,000


$65,000


October, 2020


$95,000


$70,000


November, 2020


$75,000


$30,000


December, 2020


$55,000


$35,000


January, 2021


$45,000


N/A


Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25,000 a month; lease payments under long-term lease contracts will be $7,000 a month; depreciation charges will be $8,000 a month; miscellaneous expenses will be $5,000 a month; income tax payments of $30,000 will be due in both August and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70,000, and a minimum cash balance of $30,000 will be maintained throughout the cash budget period.


a. Prepare a monthly cash budget for the last 6 months of 2020.


b. Prepare an estimate of the required financing (or excess funds)—that is, the amount of money Marvel’s Renovations will need to borrow (or will have available to invest)—for each month during that period.


c. If its customers began to pay late, this would slow down collections and thus increase the required loan amount. Also, if sales dropped off, this would have an effect on the required loan amount. Perform a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement.


Submit your answers in an Excel and/or Word document.

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:

Writer Writer Name Offer Chat

Writers are writing their proposals. Just wait here to get the offers for your project...

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

Similar Homework Questions

Rangeview rangers netball club - Earthing system of transmission tower - Romeo and juliet 2014 - Expository essay - Santa clara university essay prompts - Real-world problem &Gig economy case study - Samling group share price - What does agnes hailstones tattoo mean - Fairy tail chapter 253 discussion - Portrait head of queen tiye - How many ram chips are necessary - A raisin in the sun facts - Active directory topology diagrammer windows server 2012 r2 - Hot shots tennis t-shirt - Sin and grace in christian counseling summary - Blue parrot bluetooth headset manual - What solid has 6 faces - Cert iv in health science foundations wa - HR (LDRSHP MANA U_5_RPLx2) - Stp data transmission category - What is google's pay level - Jeremy rifkin animal rights essay - Family developmental theory nursing - Leadership Development - Requerimiento 1510 what is the intent of spain - Ich bin ein berliner analysis - Bmr based on body fat - Lab report example chemistry pdf - Harvey amwake cpa - What are wireless devices and the wireless revolution - Instructional rounds in education elmore - 67 mcraes avenue penshurst - Act government shopfront opening hours - Vold's Theoretical Criminology - PCI Compliance - Twelfth night rising action - Cell phones in school introduction - The gdp gap shrinks - Humanized robots case study solution - Green Human Resource Management - What stores sell toms shoes - Is 660 introduction to public private partnerships quizlet - Utility program in computer - Smith precept polarized photochromic sunglasses - The Thesis Statement & Annotated Bibliography Assignment - Discussion Post your tentative thesis statement for your literary analysis essay on Metamorphosis. - 1k ohm resistor color code 5 band - Morrisons swan valley northampton phone number - Chromatography of food dyes lab results - Fitness first strategy - Critical Thinking in (Marketing Management) - Romeo and juliet storyboard act 3 - America and the Free Market - Acid base titration lab questions - Scale factor calculator for coordinates - Jay belson looks like actor - Find the exact length of the curve. x = et − 4t, y = 8et/2, 0 ≤ t ≤ 5 - Brittany road st leonards - Best ratio for bubble mixture - Magnesium reacts with silver nitrate solution equation - What safeguards are included in patient portals and phrs - Ford motor company case study strategic management - If you know an sle is $100 and the associated aro is 5 months, then what is the ale? - West coast cooler dan murphys - Criminal procedure samaha 9th edition - Cp huntington train for sale - 36 essential multiplication facts - It workshop lab manual - Horizontal vs vertical and conglomerate mergers - English sba written report sample - NRS-410V-0L191 Pathophisiology and Nursing Management of Client Health. - Essay - Cgs1000 - Reading a to z guided reading lesson plans - Attention getter for speech about myself examples - Joe larkin millennium partners - The country house company - I Need Two pages Done ASAP - Trig e track merringtons - Transition metal colours list - Healthcare managers - Advanced Industrial Hygiene (200 words) - Essay - Limitations of ansoff matrix - Croajingolong national park walks - Organisational experience - How to calculate wavelength from angle of diffraction - Celia rae foote character analysis - Hierarchies jobs bodies a theory of gendered organizations - The secret life of 118 green street worksheet - What is a hemisphere - Short stories with the theme of self discovery - Classifying and balancing chemical reactions answers - NURSING - What deception is vincent trying to maintain - Curtis motors dalgety bay - Management accounting atkinson 6th edition pdf - Lc-ugrad1.gcu.edu - Toulmin's model of argument worksheet - Python Assignment