ACC127 Accounting and Financial Literacy Report
docx
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).
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
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
Conclusion
This report presented a comprehensive analysis of the business forecast budgets for Pegasus Stables, with a focus on financial and non-financial aspects for the year ending June 2024. The analysis of financial data has identified several concerns, potentially impacting future performance. These findings were used to inform financial decisions for the business,
including the purchase of land to extend services offered. This purchase, and subsequent loan application, was formally recommended.
References
Willoughby, C. (2023). Budgets and Business Reports: Pegasus Stables Financial Reports. [Unpublished assignment submitted for ACC127].
Charles Sturt University.
Appendix A
Pegasus Stables Cash Budget – Highlighted Cash Deficits (Willoughby, 2023)
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
Appendix B
Pegasus Stables Schedule of Expected Cash Receipts (Willoughby, 2023)
Appendix C
Pegasus Stables Sales Budget (Willoughby, 2023)
Appendix D
Pegasus Stables Operating Expenses Budget – Highlighted Marketing and Advertising Expenses
(Willoughby, 2023)
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
Appendix E
Pegasus Stables Operating Expenses Budget – Highlighted Loan and Principal Expenses
(Willoughby, 2023)
Appendix F
Pegasus Stables Operating Expenses Budget – Highlighted Depreciation Expense
(Willoughby, 2023)
Appendix G
Pegasus Stables Cash Budget (Willoughby, 2023)
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
Appendix H
Pegasus Stables Cash Budget – Affordability of Repayments Calculations (Monthly)
(Willoughby, 2023)
Appendix I
Pegasus Stables Expenses Variable expenses (as a percentage of monthly service revenue)
%
Grain and feed
7%
Wages
70%
Cleaning fees
5%
Professional photograph 2%
Marketing expense
3%
Other expenses
2%
Monthly fixed expenses
$
Telephone and internet charges
275
Electricity
300
Website management
300
Tack and rugs
1,500
Annual expenses
$
Insurance
13,500
Advertising
5,400
Loan (principal)
36,000
Interest on loan
1,800
Depreciation
42,000
Accounts receivable
30,000
Accounts payable
12,500
(Willoughby, 2023)
Related Questions
Flexible budget for selling and administrative expenses for a service company Social Media Inc. uses flexible budgets that are based on the following data: Sales commissions ............................................................ 15% of sales Advertising expense .......................................................... 20% of sales Miscellaneous administrative expenses ........................... $7,000 per month plus 10% of sales Office salaries expense ..................................................... $35,000 per month Customer support expenses ............................................. $11,000 per month plus 18% sales Research and development expense ................................ $35,000 per month Prepare a flexible selling and administrative expenses budget for June 2016 for sales volume $400,000, $500,000 and $600,000.
arrow_forward
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
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
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 do not give solution in image format thanku
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
Please do not give solution in image format thanku
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Prepare a budgeted balance sheet at June 30th
arrow_forward
#13 is the question
arrow_forward
Please do not give solution in image format thanku
arrow_forward
me
* CengageNOWv2 | Online teachin X
eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%=&inprogress%-false
еВook
Show Me How
E Print Item
Production Budget
Pasadena Candle Inc. projected sales of 800,000 candles for January. The estimated January 1 inventory is 35,000 units, and the desired January 31 inventory is 20,000 units.
Prepare a production budget report in units for Pasadena Candle Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Pasadena Candle Inc.
Production Budget
For the Month Ending January 31
Expected units to be sold
Desired ending inventory, January 31
Total units available
Estimated beginning inventory, January 1
Total units to be produced in January
Feedback
Check My VWork
Remember to take into account expected units to be sold, desired units in ending inventory and estimated units in beginning inventory when calculating total units to be produced.
Previous
Next
arrow_forward
How do I solve the chart?
arrow_forward
For Req #4, Can you please highlight what items I should enter into the budgeted income statement for May? Your spreadsheet has far more lines than what the question does and I am confused.
Item2
3.33points
ItemSkipped
Print
Item 2
Problem 8-19 (Algo) Cash Budget; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-8, LO8-9, LO8-10]
Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below:
Minden CompanyBalance SheetApril 30
Assets
Cash
$ 9,200
Accounts receivable
76,250
Inventory
49,750
Buildings and equipment, net of depreciation
228,000
Total assets
$ 363,200
Liabilities and Stockholders’ Equity
Accounts payable
$ 63,750
Note payable
23,900
Common stock
180,000
Retained earnings
95,550
Total liabilities and stockholders’ equity
$ 363,200
The company is in the process of preparing a budget for May and has assembled the following data:
Sales are budgeted at…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Flexible budget for selling and administrative expenses for a service company Social Media Inc. uses flexible budgets that are based on the following data: Sales commissions ............................................................ 15% of sales Advertising expense .......................................................... 20% of sales Miscellaneous administrative expenses ........................... $7,000 per month plus 10% of sales Office salaries expense ..................................................... $35,000 per month Customer support expenses ............................................. $11,000 per month plus 18% sales Research and development expense ................................ $35,000 per month Prepare a flexible selling and administrative expenses budget for June 2016 for sales volume $400,000, $500,000 and $600,000.arrow_forwardExam 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_forward
- Answer the following according to the following formatarrow_forwardmeducation.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_forwardQuestion-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_forwardPrepare 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_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.240arrow_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_forwardPlease do not give solution in image format thankuarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you