Question: Please solve A through D with an explanation. Week Three Assignment: Prepare Financial Projections a. Using the information provided, conatruct a monthly cash budget for

Please solve A through D with an explanation.

Week Three Assignment: Prepare Financial Projections a. Using the information provided, conatruct a monthly cash budget for October through December 2017. Based on your amalyais, will Noble enjoy a surplas of cash, or require external financing? b. Construct a pro forma income statement for the first fiscal quarter of 2018 (Oct through Dec. 2017) and a pro forma balance abeet as of December 31, 2017. What is your estimated external funding required for December 31 ? c. Does the December 31,2017 estimated external financing equal your cash surplus (deficit) for this date from your cash budget? d. Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2017. NOBLE EQUIPMENT CORP. 1 Cost of goods sold consists entirely of items purchased during the quarter. 2 Selling and administrative expenses consist entirely of salaries. 3 Depreciation is straight-line at the rate of $4,000 per quarter. 4 Accrued expenses are not expected to change in the last quarter. 5$25.7 due December 2017. No payments for remainder of year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Financial statements and additional information for Noble Equipment Corp. are available for download from McGraw-Hills Connect or your course instructor (see the Preface for more information). The...

more information). The company's fiscal year end is September 30 . Noble's management wants to estimate the company's cash balances for the last three months of calendar year 2017, which are the...

Hello Guys, I need your help on that new two modules. I attached them file with this email. The module # 3 is related to the module two, which I submitted in my first questions. So I attached the...

Need help with these discussion postings (in a document) and assignments (all in separate files), all directions are included as well. FINANCE DIRECTIONS Need to provide 1 original post substantial...

Healthcare Budget Project. Please see attached instructions BUSI 523 BUDGET PROJECT GRADING RUBRIC Criteria Part 1: Financial Statement Analysis Part 1: Financial Statement Analysis Part 2: Budget...

I need help with this budget assignment, I have attached the instructions BUSI 523 BUDGET PROPOSAL INSTRUCTIONS Instructions: Complete each part of the following Case Study. You will need to use...

You are nearing completion of your first year at Brandybuck, Gamgee & Took, a mid-size accounting firm that specializes in small business consulting. With multiple projects and assignments completed,...

I need help with completing the attached, can you help? FINAL PROJECT TO BE COMPLETED WEEK BY WEEK, COMMENTS REVIEWED, THEN COMPILED IN WEEK 8 FOR GRADING This first intro page (1) can be deleted...

i will add few pictures, those are the examples of that assignment. Professor left has a reference, please follow those images as a reference and complete the assignment asap. Instructions Complete...

This problem builds upon each of the different modules to a logical analysis and conclusion, emphasizing the most important aspects of business finance through the completion of each of the four...

Read the following article and write a paper about it: THE ECONOMICS OF HOMELESSNESS: THE EVIDENCE FROM NORTH AMERICA John M. Quigley and Steven Raphael

The following figure shows an Excel spreadsheet that calculates the benefit of pooling safety stock. Specically, the sheet calculates how much could be saved in annual holding costs if the safety...

Kramer Corporation has accumulated E & P of $ 1 0 0 , 0 0 0 on January 1 , 2 0 2 5 . In 2 0 2 5 , Kramer has current E & P of $ 1 3 0 , 0 0 0 ( before any distribution ) . On December 3 1 , 2 0 2 5 ,...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...