Reference no: EM132032150
Question -
A. Create a 12 month cash budget in Excel using the following assumptions:
• Initial sales of $5,000,000 with forecasted monthly growth of 1%.
• 40% of each months sales for cash; 30% for the following month ; 20% collected 2 months later; 8% collected 3 months later, and 2% never collected.
• Initial cash balance of 350,000.
B. Add a spinner to your spreadsheet that will enable you to easily change the forecasted monthly sales growth to range from .5% to 1.5% in increments of .1%.
C. Add a scroll bar to your spreadsheet that will let you modify the amount of the initial sales to vary from $4,000,000 to $6,000,000 in increments of $100,000.
D. Design appropriate data entry and processing controls to ensure the spreadsheet accuracy.
|
Discuss your career goals whenever the opportunity presents
: An elevator speech is an excellent way to convey your skills while networking and seeking employment.
|
|
Compute the amount of inventory appearing on balance sheet
: f Koontz uses a weighted average cost flow method and sells 1,500 units of inventory, the amount of inventory appearing on balance sheet
|
|
List the different entities or objects
: List the different entities or objects, logical processes, data flows, and data stores that are involved, starting from the time you submit your time sheet
|
|
Identify a position on indeed that interests you
: Identify a position on Indeed that interests you as a potential job opportunity.
|
|
Create a cash budget
: Create a 12 month cash budget in Excel using the following assumptions: Initial sales of $5,000,000 with forecasted monthly growth of 1%
|
|
Would the amount be material to the financial statements
: Ceramic Crucibles bought the Durango facility from TW Industries in 1997. Would the amount be material to the financial statements
|
|
Find the standard deviation of returns on a stock
: What is the percentage rate of return and the standard deviation of returns on a stock if the returns on this stock was 12%, -20%, 28% and 40%.
|
|
Find the present value of the perpetuity
: A Perpetuity due has annual payments of 10, 15, 20, 25....If i is a nominal rate of interest of 8% compounded quarterly, find the present value.
|
|
View a biblical worldview as affecting your desires
: Examine some potential pitfalls in your worldview or even the worldview you see upheld around you. How would you propose overcoming it?
|