-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Preparation of Financial Statements for Al suleman Electronics Store
Question
You are the new manager of the Al suleman Electronics store in the Mall of UAE. Top management of the Electronics is convinced that management training should include the active participation of store managers in the budgeting process. You have been asked to prepare a complete master budget for your store for June, July and August. All accounting is done centrally so you have no expert help on the premises. In addition, tomorrow the branch manager and the assistant controller will be here to examine your work; at that time, they will assist you in formulating the final budget document. The idea is to have you prepare the initial budget on your own so that you gain mor e confidence about accounting matters. You want to make a favorable impressions on your superiors, so you gather the following data as of May 31, 2013.
|
Cash |
AED29,000 |
Recent and Projected Sales |
||
|
Inventory |
AED434,000 |
April |
AED300,000 |
|
|
Accounts receivable |
AED369,000 |
May |
350,000 |
|
|
Net Furniture and fixtures |
AED168,000 |
June |
700,000 |
|
|
Total Assets |
AED1,000,000 |
July |
400,000 |
|
|
Accounts payable |
AED489,000 |
August |
400,000 |
|
|
Owners' Equity |
511,000 |
September |
300,000 |
|
|
Total liabilities and owners' equities |
AED1,000,000 |
|||
Credit sales are 90% of total sales. Credit accounts are collected 80% in the month following the sale and 20% in the subsequent month. Assume that bad debts are negligible and can be ignored. The accounts receivable on May 31 are the result of the credit sales for April and May.
(.20 x .90 x AED300,000) + (1.0 x .90 x AED350,000) = AED369,000.
The average gross profit on sales 38%.
The policy is to acquire enough inventory each month to equal the following month’s projected cost of goods sold. All purchases are paid for in the month following purchase.
Salaries, wages and commissions average 20% of sales; all other variable expenses are 4% of sales. Fixed expenses for rent, property taxes, and miscellaneous payroll and other items are AED55,000 monthly. Assume that these variable and fixed expenses require cash disbursement each month Depreciation is AED2, 500 monthly.
In June, AED55,000 is going to be disbursed for fixtures acquired and recorded in furniture and fixtures in May. The May 31 balance of accounts payable includes this amount.
Assume that a minimum cash balance of AED25,000 is to be maintained. Also assume that all borrowings are effective at the beginning of the month and all repayments are made at the end of the month of repayment. Interest is compounded and added to the outstanding balance each month, but Interest is paid only at the ends of months when principal is repaid. The interest rate is 10% per annum; round interest interest computations and interest payments to the nearest dollar. Interest payment may be any dollar amount, but all borrowing and repayments of principal are made in multiples of AED1,000.
- Prepare a budgeted income statement for the coming June through August quarter, a cash budget (for each of the next three months), and a budgeted balance sheet for August 31, 20X8. All operations are evaluated on a before-income tax basis, so income taxes may be ignored here.
- Explain why there is a need for a bank loan and what operating sources supply cash for repaying the bank loan.
Summary
This question belongs to accounting and discusses about budgeted income statement operating sources supply cash for a company as given in the case study.
Total word count: Excel
Download Full Solution
WHAT OUR STUDENTS SAY
I was apprehensive at first about using an online tutoring service that too for a subject as critical as mechanical engineering. But once I gave it a try I know that I need not have worried. The tutors at TheReliableTutor.com are totally in sync with what is required by me. So we are in a good place
Ashok Banerjee Student
I was apprehensive to begin with. I had bitter experiences with online service providers for assignments and homework essays during my masters. But the online dissertation help expert assigned to me by TheReliableTutor has been extremely responsible and professional in his approach to my subject of choice and the research work has been totally as I had wanted. We are on a good path I feel.
Sylvia Pilger Student
Structuring the arguments while analyzing the Civil Rights movement in America, for my term paper, was bit of a challenge for me. I was unsure of how to proceed or gather information. Researching and then jotting the entire thing down needed certain help and I got that them from HwA. Here the experts not only helped me pinpoint some topics to write but also did a marvellous job in researching and helping out with the entire assignment. It is needless to say that I received excellent grades from my term paper advisor in college.
Sharon Lynn Student
I had spent a lot on another online assignment service provider but their quality of work left a lot to be desired and most of the time I was having to redo the whole thing on my own. So I was ending up paying a bomb without getting any results. That is when my friend told me about the great quality and affordable prices of HwA. Once I gave it a try I knew I had hit gold! My grades improved a lot and I have also got a clearer understanding of the concepts of factor markets.
Ahmed Shah Student
I was using another online physics assignment help service provider. They charged me a bomb and over that they completely botched up my assignment. TheReliableTutor came as a savior and their online physics assignment help expert helped me to recover my quantum physics assignment within the deadline. The tutors listen to your requirements and provide the solutions exactly as you want them. They have a loyal customer in me now.
Brian Castor Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.