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

Mergers and acquisitions are quicker to execute than greenfield investments - The blind side inaccuracies - Tableau problem homework - Queen of the iceni - Vintage golf club brands - Point and crossing inspection - Css210 - How to measure bubble gum bubbles - River community hospital case study solution - Motorola case study - Working for eli lilly & company case study - Ucs kvm connection failed - Padded side rails for seizure precautions - Bounce shot in beer pong - Finance question - Circuit breaker symbol single line diagram - Ann marie di mambro - St patrick's church crossmaglen - Julian dream doctor comprehension questions - Interior design course perth - Mth 215 week 1 checkpoint - Kotter's 8 stages of change - Tutor Account On Sale - Pre lab questions answers biology - Qas scope of practice - Chromagen midea electric heat pump water heater - Accounting intermediate taxation - Nursing teaching plan apa format - How do tombolos form - Conventional symbols of roads - Advantages of am modulation - Justice in the crucible - Blobz guide to electric circuits - Gaussian elimination python - Dr john garside ent - What fear can teach us answers - The case study how bmw dealt with exchange rate risk - Bared to you excerpt chapter 9 - Take 5 pocket puzzler 164 - Cnh australia st marys - This world is not conclusion poem - Descriptive essay - 1578 highland ave glendale heights il 60139 - Tips on Discovering Budget-Friendly Book Editing Services - Edld 5345 week 2 assignment - Nuffield orthopaedic centre map - Personal philosophy of nursing essay - Roman crime and punishment - Cfitrainer.net login - The therapeutic powers of play 20 core agents of change - Ati the communicator clients displaying aggressive behavior - Umuc haircuts stage 3 - The topic is cells - Final Project Milestone Three: Global HR, Diversity, Risk Management, and Social Responsibility - Research Paper Draft - All bakery products list - Academic reading practice test 2 answers diabetes - Psy 410 week 2 worksheet - Marketing plan for fritz kola - Maroondah city council food safety - Summarize machiavelli's beliefs about what makes a great leader - Molecular mass of benzene - Has gone or had gone - PSY 8 - Gtech ht20 hedge trimmer - Week 2 Discussion - Prevention of intoxication on licensed premises guidelines - Google maps api mysql - Canara bank demat charges - Rank these compounds by boiling point pentane propane hexane - Tm v state of florida summary - SCIENCE Discussion(NO PLAGIARISM, A++ WORK, QUALITY, ON TIME) - Wileyplus chapter 6 answers - Two households both alike in dignity - Critical thinking consider the verdict sixth edition - Belhaven instructure - Discussion about A digital forensics professional - Q&A - George w bush library groupon - Present value of an ordinary annuity excel - We have scorched the snake not killed it metaphor - 2x 100 WORD POSITIVE FEEDBACK RESPONSE DUE 9/11 - Learning to read by frances ellen watkins harper analysis - Www pbs org wgbh nova ancient - Timothy oulton iceberg console - West oaks school meanwood - Harvey mackay 66 questions - Chateau margaux launching the third wine pdf - Kepnock state high school - Homework c9 2 recall 1 - Medicine control council act - Tv antenna tower collapse case study - Ice cream distribution model - Sqa national 5 physics assignment candidate guide - Benny hinn ministries australia - Vrhn analysis in strategic management - 38 coppin street semaphore - Explore World History and Culture - Possible conflict management and negotiation techniques - Blog Post