(Answered) One excel file submitted please attach answers in an excel

Accounting

One Excel file submitted; please attach answers in an Excel file

All calculations completed using Excel formula functions; all calculations and formulas must be shown

Prepare a comprehensive cash budget: (file is attached)

Use the format as your guide; Format has to be set up exactly as it is shown in the attached document: (format is attached)

Check figures: Cash receipts (collections) balance Aug: $20,500; Cash disbursements (all expenses) July $20,400

In addition to the preparation of the three month cash budget, provide the following descriptive analysis by addressing each of the following items fully:

1. Does the cash budget based on the given parameters provide the firm with the liquidity in needs in meeting operations for the quarter (and why)?

2.The CFO wants to know what is the impact of increasing the minimum monthly balance to $7,000. Provide a short but detailed response to the CFO on the impact of this change. Or course the CFO will expect to see the numerical values that support the response.

3 What is the impact of interest rate changes on the a) the budget as proposed, and b) the CFOs request for higher minimum cash balance?

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M92649623
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question -a identify at least two reasons why an accrual

Question - a. Identify at least two reasons why an accrual accounting income statement is more useful for analyzing business performance than a cash flow based income statement. b. Describe what would be reported on the ...

Question - restricted stockon december 31 2014 ying

Question - Restricted Stock On December 31, 2014, Ying Corporation granted 5,000 shares of its $1 par value common stock to certain of its key employees. The shares are restricted until 2 years of employment is completed ...

Question - on january 1 park corporation and strand

Question - On January 1, Park Corporation and Strand Corporation had condensed balance sheets as follows: Park Strand Current assets $ 115,000 $ 22,150 Noncurrent assets 93,000 44,100 Total assets $ 208,000 $ 66,250 Curr ...

Question - on january 1 2017 pina corporation sold a

Question - On January 1, 2017, Pina Corporation sold a building that cost $258,210 and that had accumulated depreciation of $105,500 on the date of sale. Pina received as consideration a $248,210 non-interest-bearing not ...

Question - the annual report can be downloaded from the

Question - The Annual Report can be downloaded from the website for Fletcher Building annual-report. Refer to Note-4 on page 65 of the Annual Report 2017, identify what are the "significant items" in 2017 and discuss the ...

Question - assume that green cos total assets at the end of

Question - Assume that Green Co.'s total assets at the end of the prior year and at the end of the current year were $937,000 and $1,019,000, respectively. Calculate ROI (based on operating income) for the current year u ...

Question - if colleen mooney invests 476550 now and she

Question - If Colleen Mooney invests $4,765.50 now and she will receive $12,000 at the end of 12 years, what annual rate of interest will Colleen earn on her investment? Compute the number of periods of a single amount. ...

Question - on january 1 2017 shay issues 700000 of 10

Question - On January 1, 2017, Shay issues $700,000 of 10%, 15-year bonds at a price of 97¾. Six years later, on January 1, 2023, Shay retires 20% of these bonds by buying them on the open market at 104½. All interest is ...

Question -bella requires 232000 in four years to purchase a

Question - Bella requires $232000 in four years to purchase a new home. What amount must be invested today in an investment that earns 5% interest, compounded annually? Swifty Corporation will receive $21500 today (Janua ...

Question - you are the controller of harmon oil a

Question - You are the Controller of Harmon Oil, a medium-sized oil exploration company in Texas. It is time to make a forecast of the company's annual earnings. You know that additional losses will be recognized before ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert