Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could I see an example of the line item operating AND cash budget reports? if more informarion is beeded let me know, but im not

image text in transcribedcould I see an example of the line item operating AND cash budget reports?
image text in transcribed
image text in transcribed
if more informarion is beeded let me know, but im not sure what format to put the information into.
OMG...
please and thank you!!
sorry
n Prepare a line item Operating Budget for the following (next) year using the Current Year numbers and the assumptions about chan subsequent quest ges in individual line items. You will find that this, and ions, can be answered more easily if you prepare your work in a spreadsheet the CWC's surplus or deficit for the current year as a dollar amount and as a a) Calculate percent of annual expense. b) Without much information about the organization, does any ONE expense seem unusually high/low during the current year? Use the assumptions concerning changes in the various revenue and expense line items to calculate the CWC's surplus or deficit for the next year as a dollar amount and as a percent of annual expense Does the budget for the next year meet their goal of a 5% (percent of annual expense) budget surplus? c) d) e) Calculate the amount they need to cut (or have as an extra surplus). Suggest alternatives for achieving the 5% budget surplus target. penses occur on 2) Prepare a quarterly cash budget for the next year. Assume all revenue and ex the last day of each quarter. Also assume a $40,000 beginning cash balance. Add i% each quarter based on the beginning of quarter cash balance (01 x beginning of quarter cash balance) as interest income. Re-calculate the "Interest Income" line item for the year. a) Does the CWC have adequate cash reserves to get them thru the year? b) How large (calculated both as a dollar amount and as a percent of annual expense) is the lowest quarterly ending cash balance? c) If they lack sufficient cash flow, what might they do to correct the problem? d) Why did the Interest Income line item increase (decrease) from the budgeted amount? n Prepare a line item Operating Budget for the following (next) year using the Current Year numbers and the assumptions about chan subsequent quest ges in individual line items. You will find that this, and ions, can be answered more easily if you prepare your work in a spreadsheet the CWC's surplus or deficit for the current year as a dollar amount and as a a) Calculate percent of annual expense. b) Without much information about the organization, does any ONE expense seem unusually high/low during the current year? Use the assumptions concerning changes in the various revenue and expense line items to calculate the CWC's surplus or deficit for the next year as a dollar amount and as a percent of annual expense Does the budget for the next year meet their goal of a 5% (percent of annual expense) budget surplus? c) d) e) Calculate the amount they need to cut (or have as an extra surplus). Suggest alternatives for achieving the 5% budget surplus target. penses occur on 2) Prepare a quarterly cash budget for the next year. Assume all revenue and ex the last day of each quarter. Also assume a $40,000 beginning cash balance. Add i% each quarter based on the beginning of quarter cash balance (01 x beginning of quarter cash balance) as interest income. Re-calculate the "Interest Income" line item for the year. a) Does the CWC have adequate cash reserves to get them thru the year? b) How large (calculated both as a dollar amount and as a percent of annual expense) is the lowest quarterly ending cash balance? c) If they lack sufficient cash flow, what might they do to correct the problem? d) Why did the Interest Income line item increase (decrease) from the budgeted amount

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Debunked An Auditor Reviews The 2020 Election And The Lessons Learned

Authors: Joseph Fried

1st Edition

1645720756, 978-1645720751

More Books

Students also viewed these Accounting questions