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

Reputation & Stakeholder Audit - Prevention of intoxication on licensed premises guidelines - Define periodization and its components - American university sis admissions - Acc 291 exercise 8 11 - Standard cost and variance analysis matrix - Suffer the little children pennhurst documentary - Kingspan k10 soffit board - Epson 212 ink jb hi-fi - What happens at the end of chinese cinderella - How to make a 3d cell model - Psychotherapy With Individuals - Deakin late submission policy - Cultural Diversity - Homemade foal milk replacer - Dolgoff ethical decision making screen - The iron law of responsibility says that - How To Find A Personal Statement Writing Service - Adding fractions butterfly method - Designing a zip line math problem answer - What is the bus in a computer - Emc powermax administration guide - Spaghetti noodle tower challenge - Warning letter for not wearing safety shoes - Cost accounting involves the measuring recording and reporting of - Force and motion ppt - How many protons are in a boron atom - Romeo and juliet spoof - Surry hills parking permit - Health related informative speech topics - Qdx f px - A company that pursues and achieves strategic objectives - transformational leadership - Develop a hypothesis relating to the amount of dissolved oxygen - Gaia cs umass edu wireshark labs - Andrew carnegie on the triumph of america 1885 - Convert pcap to netflow - Transformar write the superlative form of each adjective. alta buenos simpático viejas grande - A horizontal aluminum rod 4.8 cm in diameter - Jim and jeff thiel - 3 lags of fiscal policy - Stupid zombies chapter 2 stage 4 level 39 - Transformational leadership essay - Easy rider death scene - Sketch and label dna replication - Internships course - Bushy park pony club - 2 paragraphs - Bellamy's organic swot analysis - Stuart sharp angeli symphony cd - Analysis with essay - 5 point star gang sign - Which of the following is a capital budgeting decision - Astor mickey mouse radio - Scenario analysis cars sold - Danny shadow health cough - Chemical energy stored in food - Summary of against nature by joyce carol oates - A Social Invitation - Greenwich village society for historic preservation - The yellow wallpaper notes - Certificate iv in professional writing and editing rmit - Bupa level 2 717 bourke street docklands - Nick sharratt drawing tips - Examples of menu driven program - FUNCTION FOCUSED CARE - AMH - Uae palm tree island - Discussion - Https static practicefusion com apps ehr login - Tiffany and co competitors - Credit card starting with 37 - Jc cueva teen mom 2 - Disaster Recovery Plan - Tata starbucks case study analysis - Sam walton jay z by george packer - Alibaba goes public case study - GLORIA TAPES CRITIQUE - Google human resource management case study - Copper reacts with silver nitrate - Vulnerabilities of wireless lan - Physics vce cheat sheet - Data mining in social media ppt - If the demand for bacon is relatively elastic, a 10 percent decline in the price of bacon will - Pledge of allegiance words under god - Models for writers 13th edition - Hierarchy chart pseudocode - The white water rapids metaphor envisions an organization as ________ - Six and nine tenths as a decimal - Disgronificator - Penn foster music appreciation exam answers - Lennons circus gold coast - .79 inches to fraction - Eight steps to sound ethical decision making - Business Intelligence(Assign1) - WK2 Discussion 2 HSC4010 Epidemiology and disease control - Recitational questioning - Wrexham council bin not emptied - Chose in a sentence - Compare Impact of Treaty of Versailles (Plagiarism Checked) Submit Assignment