ACC127 Accounting and Financial Literacy Report
.docx
keyboard_arrow_up
School
Charles Sturt University *
*We aren’t endorsed by this school
Course
127
Subject
Accounting
Date
Jan 9, 2024
Type
docx
Pages
17
Uploaded by CoachArt6885
ACC127 Accounting and Financial Literacy
Claire Willoughby (117196561)
Assessment 3
Report: Budgets and Business Reports Value: 20%
Due Date: 20-Sept-2023
Return Date:13-Oct-2023 Length: 700 words +/- 10%
Submission Method: EASTS Assignment Portal
Word Count: 770
Table of Contents
Issues with Business Forecast Budgets
................................................................................
3
Affordability of Repayments
...............................................................................................
4
Additional Factors to be Considered
...................................................................................
5
Recommendation
...............................................................................................................
6
Conclusion
..........................................................................................................................
7
References
.........................................................................................................................
8
Appendix A
.........................................................................................................................
9
Appendix B
.......................................................................................................................
10
Appendix C
.......................................................................................................................
11
Appendix D
.......................................................................................................................
12
Appendix E
.......................................................................................................................
13
Appendix F
.......................................................................................................................
14
Appendix G
.......................................................................................................................
15
Appendix H
.......................................................................................................................
16
Appendix I
........................................................................................................................
17
Issues with Business Forecast Budgets Financial Considerations The cash budget for September and October shows a substantial discrepancy between the forecasted cash inflows and outflows, resulting in a cash deficit of -$1492.94 and -$862.03, respectively (See Appendix A). This discrepancy suggests probable liquidity issues during these months, raising concerns about the business’s capacity to meet any short-term financial obligations. The balance of accounts receivable steadily increases with the seasonal demand of Pegasus Stables’ services throughout the reporting period (See Appendix B). Whilst this can indicate an increase in sales, this can also represent delayed cash receipts, which further affects the business’s capacity to pay current expenses. The budgeted sales exhibit a declining trend from May to August, representing a reduction in expected income over the year, potentially leading to financial difficulties if not addressed
(See Appendix C). Whilst this is explained through the seasonal demands of services provided by Pegasus Stables, this necessitates an examination of sales strategies to ensure capability to cover expenses. Non-Financial Considerations
A consideration of the effectiveness of the marketing and advertising in increasing cash inflow is crucial. The budget for both expenses is relatively consistent throughout the year (See Appendix D). Due to the declining trend in sales through May to August, evaluating the
effectiveness of these strategies and considering adjustments to increase sales is essential. It is crucial to evaluate the purpose of the loan and how it affects business operations. Currently, the total loan repayment and principal both fall due in March of each year (See Appendix E). Whilst the purpose for the loan has not been disclosed, the consideration of other payment options may prove beneficial to the business, easing financial burdens across
the year. This may also help to alleviate any financial stress the business experiences during the period in which sales trends have shown a decline and periods when expenses are recorded as higher. The acknowledgement of the allocation of depreciation across the 12-month reporting period is vital when evaluating business profitability. Depreciation is a non-cash expense, and therefore, does not affect the outflow of cash for the business. However, it has the potential to affect the overall financial situation of Pegasus Stables by providing a clear representation of the value of current assets, all of which are necessary for the operation of a service-based business (See Appendix F).
Affordability of Repayments The affordability of repayments has been calculated based on the financial data and information provided up to June 2024 (See Appendix G). Any changes in the business or financial circumstances beyond this date may impact the capacity of Pegasus Stables to meet repayment obligations. Furthermore, the loan terms, interest rates and any additional financial obligations will determine the feasibility of taking out a loan in the current financial
position of the business. In determining the affordability of repayments (See Appendix H), a monthly average of excess cash receipts has been calculated to meet monthly repayment obligations. A margin of 50% (See Appendix H) has been left from this average, to ensure financial stability and cushioning for predicted expense increases, coinciding with business expansion. This will also allow for a margin if sales are not to increase immediately after purchase of the land, given the predication that this expansion will generate further sales revenue through the offering of additional services for customers.
Additional Factors to be Considered
There are additional factors that should be considered before purchasing the land. Increased Expenses The current amount of expenses incurred by Pegasus Stables, including all variable, most monthly and some annual expenses are likely to increase proportionate to the costs associated with purchasing land (See Appendix I). Whilst the total cost of these increases cannot be calculated, Pegasus Stables must be aware of this and ensure adequate cash flow to cover all loan repayment obligations and increased cash outflow. Market Demand and Competition
An analysis of the current demand for additional horse related services in the area is crucial to informing the decision of purchasing land. Whilst the purchase of this land could prove beneficial to the performance of Pegasus Stables, this relies on increased customer demand that they cannot fulfil with their current assets.
Recommendation
Based on the analysis, it is recommended that Pegasus Stables proceed with obtaining a loan for land acquisition. The business’s current financial position demonstrates that it is capable of supporting this expansion, however, continued financial diligence is advised.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Exam
Business XYZ has the following projected budget
and actual budget for a given month:
Budget Actual
$25,000 25,575
Рayroll
Inventory 12,500 11,900
Rent
7,500
7,600
Services
5,000
5,200
Calculate the percent change that the total of all
categories is over budget.
[?]%
Give your answer as a percent rounded to the nearest tenth.
Enter
Copyright 2003 - 2021 Acellus Corporation. All Rights Reserved.
arrow_forward
ezto.mheducation.com/ext/map/index.html?_con3Dcon&external_browser%3D0&launchUrl%3Dhttps%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-g
hapter 18- Problems i
Saved
Help
Save & Exit
The following is the sales budget for Yellowhead Inc. for the first quarter of 2018:
1
January
February
$235,000
March
Sales
$215,000
$258,000
Credit sales are collected as follows: 55% in the month of the sale, 30% in the month after the sale, and 15% in the second month after
the sale.
Skipped
The accounts receivable balance at the end of the previous quarter was $99,000 ($69,000 of which was uncollected December sales).
a. Calculate the sales for November. (Omit $ sign in your response.)
November sales
24
b. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit $ sign in your response.)
December sales
c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations.
Round the final answers to 2…
arrow_forward
Answer the following according to the following format
arrow_forward
meducation.com/ext/map/index.html?_con%3con&external_browser%3D0&launchUrl=https%253A%252F%252FIM..mheducation.com%252Fmghm
Saved
Help
Sa
2 & 14 Recap i
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at
least $8,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and
Repayments should be indicated by a minus sign.)
Quarter (000 omitted)
(000 omitted)
2
3
4
Year
Cash balance, beginning
9
Add collections from customers
99
348
Total cash available
87
Less disbursements:
nces
Purchase of inventory
38
48
30
Selling and administrative expenses
30
30
121
Equipment purchases
10
10
13
43
Dividends
2
2
Total disbursements
90
Excess (deficiency) of cash available over disbursements
(2)
16
Financing:
Borrowings
14
Repayments (including interest)*
(17)
Total financing
Cash balance, ending
"Interest will total $1,000 for the year.
9.
7
8.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
* CengageNOWv2 | Online teachin x
ome
keAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
еBok
Show Me How
Print Item
Personal Budget
At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough ca
December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
Cash balance, September 1 (from a summer job)
$9,250
Purchase season football tickets in September
160
Additional entertainment for each month:
250
Pay fall semester tuition in September
4,800
Pay rent at the beginning of each month
600
Pay for food each month.
550
Pay apartment deposit on September 2 (to be returned December 15)
600
Part-time job earnings each month (net of taxes)
1,200
a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outflows, a…
arrow_forward
Question-4
REQUIRED
Use the information provided by Empire Traders to prepare the following for March and
April 2024:
4.1 Debtors Collection Schedule
4.2 Cash Budget.
INFORMATION
The following information was provided by Empire Traders:
1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024.
2. Budgeted sales figures for 2024 are as follows:
3.
4.
5.
6.
7.
Cash sales
Credit sales
9.
January
R320 000
R370 000
Total purchases
February
R370 000
R390 000
March
R310 000
R320 000
Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%.
Collections from debtors are usually as follows:
• 80% is collected in the month after the sale.
20% is collected two months after the sale.
Purchases of inventory are expected to be as follows:
January
February
R410 000
R460 000
April
R250 000
R300 000
March
R400 000
April
R380 000
Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance…
arrow_forward
Question 7. Please fill in the blanks the same format as the question
arrow_forward
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires aminimum cash balance of at least $5,000 to start each quarter.Quarter1 2 3 4 YearCash balance, beginning ............................ $ 6 $ ? $ ? $ ? $ ?Add collections from customers ................. ? ? 96 ? 323Total cash available ................................... 71 ? ? ? ?Less disbursements:Purchase of inventory ............................. 35 45 ? 35 ?Operating expenses ................................ ? 30 30 ? 113Equipment purchases ............................. 8 8 10 ? 36Dividends ................................................ 2 2 2 2 ?Total disbursements .................................... ? 85 ? ? ?Excess (defi ciency) of cash availableover disbursements ................................. (2) ? 11 ? ?Financing:Borrowings .............................................. ? 15 — — ?Repayments (including interest)* ............ — — (?) (17) (?)Total fi nancing…
arrow_forward
Prepare an actual versus budget income statement with horizontal analysis accounting information using the data in 4.23 in chapter 4 shown above and the following budget data for January
Don't use any AI.
Help me please asap.
Don't use handwritten image format.
Thanks
arrow_forward
Suggest five internal strategies that may be employed by management to improve an organization monthly cash flow and militate against or reduce any possible shortfall reflected in the budget prepared
arrow_forward
Please answer in text form (without image)
arrow_forward
Customers
balance December 31, 2023
om customers
e balance, March 31, 2024:
cted in 2nd Ot
2024
Data table
Total sales
Budgeted purchases of direct matenal
Budgeted direct labor cost
Budgeted manufacturing overhead costs
Variable manufacturing overhead
Depreciation
Insurance and property taxes
Budgeted selling and administrative expenses
Salaries expense
Rent expense
Insurance experese
Depreciation experie
Supples expense
Print
Done
208.000
40,900
37,500
1,100
1.200
6,700
4,000
1,000
1,400
6.240
arrow_forward
* CengageNOWv2 | Online teachin x
.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false
Cash Budget
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:
May
June
July
Sales
$146,000 $185,000 $248,000
Manufacturing costs
61,000
80,000
89,000
Selling and administrative expenses
42,000
50,000
55,000
Capital expenditures
60,000
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second
month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual
property taxes are paid in November. Of the remainder of the manufacturing costs, 85% are expected to be…
arrow_forward
Please provide answer in text (Without image)
arrow_forward
P
00
it View
History
Bookmarks
Window
Help
00
A ezto.mheducation.com
nt Portal
Course Modules: Budgeting and Forecasting 62211
Week 4: Homework
Question 3 - Week 4: Homework - Co
omework G
Saved
Help
Save & Exit
Submit
Check my work
Information pertaining to Noskey Corporation's sales revenue follows:
November 2021
(Actual)
$ 180,000
December 2021
(Budgeted)
$ 160,000
500,000
January 2022
(Budgeted)
Cash sales
000'09
$ 540,000
Credit sales
$ 360,000
000'09
Total sales
000'099 2$
Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the
remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month's projected
total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on-account;
25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase.…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Exercise 7 (Cash Budget Analysis)
A cash budget, by quarters, is given below for a retail company. (000 omitted).
The company requires a minimum cash balance of P5,000 to start each quarter.
Quarter
1 2 3 4 Year
Cash balance, beginning..................... P9 P? P? P? P?
Add collections from customers….. ? ? 125 ? 391
Total cash available………………. 85 ? ? ? ?
Less disbursements:
Purchase of inventory….................. 40 58 ? 32 ?
Operating expenses…………... ? 42 54 ? 180
Equipment purchases…................ 10 8 8 ? 36
Dividends…………………….. 2 2 2 2 ?
Total disbursement………………..…
arrow_forward
X
Search the web
↑
EXPERT
SOLUTION
FOLLOW-UP
QUESTIONS
↓
Homework help starts here!
← Q&A Library
τυιαι Γαγiicit
Net cash flow
Beginning cash ance
Ending cash balance
Step 5 Budgeted Income Statement
Budgeted Income Statement for May
Sales
Less: Cost of Purchase consumed
(30000+120000-40000)
Gross Profit
Less:
Selling and Adm. Expenses
Depreciation
Interest on Notes Payable
Total
Net Income
Step 6 Budgeted Balance Sheet
Minden Company
Budgeted Balance sheet as on May 31
Assets
Cash
The company is in the process of preparing a budget...
204TUU
-100
9000
8900
Amount $
72000
2000
100
Amount $
200000
110000
90000
74100
15900
Amount $
ASK AN EXPERT CHAT | √ MATH SOLVER
8900
where from 9
arrow_forward
#15 is the question
arrow_forward
Please do not give solution in image format thanku
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Please show all work
arrow_forward
Don't give answer in image format
arrow_forward
152.
Subject :- Accounting .......
arrow_forward
Accounting
Budget Fixed FOH=800
Actual HRS=120
Stand HRS=150
Norm HRS= 100
Actual Fixed FOH=815
1.Find Fixed FOH Rate
2.Find BUDGET VAR
arrow_forward
Please do not give solution in image format thanku
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads
$000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425
2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…
arrow_forward
Hope you can answer and provide picture with the right format. Thankyou!
arrow_forward
Question 2: (): A1, C2, C3
"In the annual meeting of Brixton company, the Head of the accounting department
of the company suggested to the top Management to switch the budgetary system
from Zero-based budget to Rolling budget "
Required: What is the budgetary setting style in Brixton Company? And Briefly Explains
the differences between Rolling budgetary and Zero-based budgets.
arrow_forward
Prepare a budgeted balance sheet at June 30th
arrow_forward
The management of Mecca Copy, a photocopying center located on University Avenue, has compiled thefollowing data to use in preparing its budgeted balance sheet for next year:Ending BalancesCash ..................................................................... ?Accounts receivable ............................................. $8,100Supplies inventory ................................................ $3,200Equipment ............................................................ $34,000Accumulated depreciation .................................... $16,000Accounts payable ................................................. $1,800Common stock ...................................................... $5,000Retained earnings ................................................ ?The beginning balance of retained earnings was $28,000, net income is budgeted to be $11,500, and dividends are budgeted to be $4,800.Required:Prepare the company’s budgeted balance sheet.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Exam Business XYZ has the following projected budget and actual budget for a given month: Budget Actual $25,000 25,575 Рayroll Inventory 12,500 11,900 Rent 7,500 7,600 Services 5,000 5,200 Calculate the percent change that the total of all categories is over budget. [?]% Give your answer as a percent rounded to the nearest tenth. Enter Copyright 2003 - 2021 Acellus Corporation. All Rights Reserved.arrow_forwardezto.mheducation.com/ext/map/index.html?_con3Dcon&external_browser%3D0&launchUrl%3Dhttps%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-g hapter 18- Problems i Saved Help Save & Exit The following is the sales budget for Yellowhead Inc. for the first quarter of 2018: 1 January February $235,000 March Sales $215,000 $258,000 Credit sales are collected as follows: 55% in the month of the sale, 30% in the month after the sale, and 15% in the second month after the sale. Skipped The accounts receivable balance at the end of the previous quarter was $99,000 ($69,000 of which was uncollected December sales). a. Calculate the sales for November. (Omit $ sign in your response.) November sales 24 b. Calculate the sales for December. (Round the final answer to 2 decimal places. Omit $ sign in your response.) December sales c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations. Round the final answers to 2…arrow_forwardAnswer the following according to the following formatarrow_forward
- meducation.com/ext/map/index.html?_con%3con&external_browser%3D0&launchUrl=https%253A%252F%252FIM..mheducation.com%252Fmghm Saved Help Sa 2 & 14 Recap i A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $8,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) (000 omitted) 2 3 4 Year Cash balance, beginning 9 Add collections from customers 99 348 Total cash available 87 Less disbursements: nces Purchase of inventory 38 48 30 Selling and administrative expenses 30 30 121 Equipment purchases 10 10 13 43 Dividends 2 2 Total disbursements 90 Excess (deficiency) of cash available over disbursements (2) 16 Financing: Borrowings 14 Repayments (including interest)* (17) Total financing Cash balance, ending "Interest will total $1,000 for the year. 9. 7 8.arrow_forwardPlease do not give solution in image format thankuarrow_forward* CengageNOWv2 | Online teachin x ome keAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false еBok Show Me How Print Item Personal Budget At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough ca December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $9,250 Purchase season football tickets in September 160 Additional entertainment for each month: 250 Pay fall semester tuition in September 4,800 Pay rent at the beginning of each month 600 Pay for food each month. 550 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,200 a. Prepare a cash budget for September, October, November, and December. Use the minus sign to indicate cash outflows, a…arrow_forward
- Question-4 REQUIRED Use the information provided by Empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget. INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024. 2. Budgeted sales figures for 2024 are as follows: 3. 4. 5. 6. 7. Cash sales Credit sales 9. January R320 000 R370 000 Total purchases February R370 000 R390 000 March R310 000 R320 000 Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: • 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January February R410 000 R460 000 April R250 000 R300 000 March R400 000 April R380 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance…arrow_forwardQuestion 7. Please fill in the blanks the same format as the questionarrow_forwardA cash budget, by quarters, is given below for a retail company (000 omitted). The company requires aminimum cash balance of at least $5,000 to start each quarter.Quarter1 2 3 4 YearCash balance, beginning ............................ $ 6 $ ? $ ? $ ? $ ?Add collections from customers ................. ? ? 96 ? 323Total cash available ................................... 71 ? ? ? ?Less disbursements:Purchase of inventory ............................. 35 45 ? 35 ?Operating expenses ................................ ? 30 30 ? 113Equipment purchases ............................. 8 8 10 ? 36Dividends ................................................ 2 2 2 2 ?Total disbursements .................................... ? 85 ? ? ?Excess (defi ciency) of cash availableover disbursements ................................. (2) ? 11 ? ?Financing:Borrowings .............................................. ? 15 — — ?Repayments (including interest)* ............ — — (?) (17) (?)Total fi nancing…arrow_forward
- Prepare an actual versus budget income statement with horizontal analysis accounting information using the data in 4.23 in chapter 4 shown above and the following budget data for January Don't use any AI. Help me please asap. Don't use handwritten image format. Thanksarrow_forwardSuggest five internal strategies that may be employed by management to improve an organization monthly cash flow and militate against or reduce any possible shortfall reflected in the budget preparedarrow_forwardPlease answer in text form (without image)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you