Expenses of Business Assignment
7 Pages1370 Words171 Views
Added on 2021-02-21
Expenses of Business Assignment
Added on 2021-02-21
ShareRelated Documents
DHICT
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1TASK 1............................................................................................................................................1Description about the company...................................................................................................1Statement showing details regarding sale and expenses of business for 12 months forsupporting the loan request of the company................................................................................1Chart showing expenses of the company.....................................................................................2Chart showing estimated sources of income of the company.....................................................3TASK 2............................................................................................................................................3Explaining approach to design the spreadsheet and appropriateness of formula used fordesigning spreadsheet..................................................................................................................3CONCLUSION................................................................................................................................4CONCLUSION................................................................................................................................4REFERENCES................................................................................................................................5
INTRODUCTIONThe present study shows cash budget of XYZ Ltd. which is a company relating to theretail industry in order to get loan from bank. Further, it shows graphical representation ofvarious estimated expenses and income of the company. It also includes a spreadsheet showingthe use of various formulae along with benefits of these formulae. TASK 1Description about the companyXYZ Ltd. is a company performing its business in the retail industry. It is a wellestablished business that wants to expand its business activities. As per the estimation ofmanagers, by expanding business, XYZ Ltd, would be able to generate more profit from thebusiness activities. For the expansion purpose, it has taken a sum of 10000 from family andfriends. In addition, the company is in need of more funds amounting to 2500 for capital and50000 for purchase of goods. For arrangement of such needs, the company wants to take loanfrom bank. Statement showing details regarding sale and expenses of business for 12 months for supportingthe loan request of the companyStatement showing estimated cash receipts and payments for 12 monthsParticularsJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberCash at thebeginning70005195050400510505320056250580006235065960722808066090720estimated cashinflowsCash sales6500780010000115001320012000146001500016700175301900021000collection fromcreditors120030003200240031002700300033003540450054006000Bank loan5250000000000000interest oninvestment0300300400400500600600800900900900Total cashinflows67200630506390065350699007145076200812508700095210105960118620estimated cashoutflowpayment made tosuppliers300031503400365040004200460048404970500052405300operating4000425032003250340030004000320035004300475050001
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Business Decision Makinglg...
|20
|563
|162
Online Exam - Accounting for Businesslg...
|8
|648
|155
Financial Accounting: Income Statement, Statement of Financial Position, Assumptions, and Cash Flow Statementlg...
|7
|761
|51
Management Accounting: Cost Analysis and Profitability Assessmentlg...
|15
|2543
|226
Principle of Cost and Management Accountinglg...
|3
|491
|30