Answered step by step
Verified Expert Solution
Question
1 Approved Answer
These are all the information I have. QUESTION A B C Laura WIL SILU UL LS Uly gap Uy Ipurung luc cunicu and available capital
These are all the information I have.
QUESTION A B C
Laura WIL SILU UL LS Uly gap Uy Ipurung luc cunicu and available capital in Excel. Exercise 2 Foundation The Sticky Needle runs a creative center that offers various courses such as: knitting, crochet, quilting, cross stitching and even textile paining and colouring, and textile crafts. One's a year The Sticky Needle organizes an exhibition with textile art and craft supplied by the course members. These exhibitions have acquired a certain regional status. Due to this, the foundation is financially supported by several companies and donations are received from private individuals. The treasurer of the foundation's committee has made a financial report for 2019. Cash flow statement (in euros Cash Outdows Rent of the building 18,500.00 Salary manager of the center 28,500.00 Fees paid to the instructors 12.000.00 Purchase of materials 5,550.00 Energy and water 8,250.00 Management expenses 11.450 Cleaning costs 5,800.00 Insurances 4.165. Interest 1,718.75 Redemption bank loan 7.500.0 Miscellaneous 2,500.75 Total Cash-out 195.934 40 Cash inclow Course foes 160.000. Subsidies council 9,750.00 Subsidies government 4.500.00 Intrance fees exhibitions 2.775. Sa Donations from private persons 450.00 Sponsor contributors 7,350.00 Miscellaneous 1.350 Total cash-in 86.175.50 TA -9.759.00 To finance all of this, a bank loan of 75,000 euros will be available from 1-1-2019 at an annual interest rate of 2,5%. The interest is paid per month at the beginning of the next month. This bank loan must be repaid within 10 years. The redemption is always carried out at the end of the year, on 31 December. The board of directors of the foundation gathers in a slight state of panic. The loss of 9,759 is very worrying and an immediate increase in course fees is considered. A new member of the board, with a background in financial management, remarks that the overview is based on cash and cash equivalents and that, based on this, no conclusions can be drawn with respect to profit and losses of the foundation. The overview only shows that the cash and cash equivalents have reduced by 9,759. It is therefore incorrect to call this a loss. Whether there is a positive or a negative operating result remains to be seen. Further examination shows that: On December 31, 2018 a new knitting machine was purchased for 4,000. The lifespan is set to eight years. The residual value after 8 years of service is estimated to be 250 and a straight-line depreciation method is applied. The rent for yo u 2 019. Entrance fees exhibitions Donations from private persons Sponsor contributors Miscellaneous Total cash-in Loss 2,775.50 450.0 7,350.00 1.350. 186.175.50 1-9.759.00 To finance all of this, a bank loan of 75,000 euros will be available from 1-1-2019 at an annual interest rate of 2,5%. The interest is paid per month at the beginning of the next month. This bank loan must be repaid within 10 years. The redemption is always carried out at the end of the year, on 31 December The board of directors of the foundation gathers in a slight state of panic. The loss of 9,759 is very worrying and an immediate increase in course fees is considered. A new member of the board, with a background in financial management, remarks that the overview is based on cash and cash equivalents and that, based on this, no conclusions can be drawn with respect to profit and losses of the foundation. The overview only shows that the cash and cash equivalents have reduced by 9,759. It is therefore incorrect to call this a loss. Whether there is a positive or a negative operating result remains to be seen. Further examination shows that: On December 31, 2018 a new knitting machine was purchased for 4,000. The lifespan is set to eight years. The residual value after 8 years of service is estimated to be 250 and a straight-line depreciation method is applied. The rent for 2 years is paid at the start of 2019. The subsidies from the council are 3,250 per quarter and the subsidy was currently not received for the final quarter of 2019. Of the 5,550 purchased materials (wool, colouring agents, textiles, etc.) there was still an inventory of 350 at the end of 2019. The insurance premium for 2019 of 2,250 was paid in January 2019 but the premium for 2020 was paid in December 2019, for which a reduction of 335 was received. End of 2019, course members paid 5.000 in advance for courses that start in 2020. The cost of the loan was not properly accounted for. Question A: Construct the starting balance sheet of 1-1- 2019, assuming the inventory is 155 at that time, Equity -0. (1 point) Question B: Construct the correct Income statement for 2019. Use (1) the relevant information from the 1st overview and (2) the information from the supplementary survey. (4 points) Question C: Construct the final balance sheet of 31-12- 2019. (5 points)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started