i need it in excel sheet format please

i need the answer in excel sheet please

Submit excel file only. Ruby Co. is a small company that manufactures and sells silk carpets in Abu Dhabi. The found of this company is Khaled Saeed, and he is in charge of the design and sale of the carpets, but his background is only in making silk carpets, not business As a result, the company's financial records are not well maintained. The initial investment in Ruby Co. was provided by Khaled and his family. Because the initial investment was relatively small, and the company has made carpets only for its own store, the investors haven't required detailed financial statements from Khaled. However, because the quality of the carpets is very good, sales of the carpets have increased rapidly in the recent months and Khaled is considering a major expansion. His plans include opening another store in Dubai, as well as selling his carpets to other customers in Saudi Arabia Khaled's expansion plans require a significant investment, which he plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. The new investors and banks require Khaled to provide them with more organized and detailed financial statements than he has previously prepared. In order to do that, he hired a financial analyst, her name is Fatima (she holds a bachelor degree in finance from ADU University). He asked Fatima to evaluate the performance of the company over the past year. After going through all the bank statements, sales receipts, tax returns, and other records, Fatima has assembled the following information: 2018 2019 Cost of goods sold Cash Depreciation laterestepen Scling & Administrative Accountable 32,372 63.334 13.733 44.121 57.220 279.419 34,394 71.54 15.70 57.5 6344 148 508 536 483 29,755 28,474 158365 66.244 440,122 Sales Accounts receivable Noles payable Long-term debet laventory New uity 22.99 26,074 141.040 48.272 Ruby Co. currently pays out 50 percent of net income as dividends to Khaled and other original investors and has a 21 percent tax rate. You are working with Fatima, and she asked you to prepare the following: 1. Income statement for 2018 and 2019. (4 marks) 2. A balance sheet for 2018 and 2019. (4 marks) 3. Operating cash flow for 2018 and 2019. (2 marks) 4 Cash flow from assets for 2019. (2 marks) s. Cash flow to creditors for 2019.(2 marks) Cash flow to stockholders for 2019. (2 marks) 7. After preparie Fatima has asked you to 2012 mon and Khaled is considering a major expansion. His plans include opening another store in Dubai, as well as selling his carpets to other customers in Saudi Arabia. Khaled's expansion plans require a significant investment, which he plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. The new investors and banks require Khaled to provide them with more organized and detailed financial statements than he has previously prepared. In order to do that, he hired a financial analyst, her name is Fatima (she holds a bachelor degree in finance from ADU University). He asked Fatima to evaluate the performance of the company over the past year. After going through all the bank statements, sales receipts, tax returns, and other records, Fatima has assembled the following information: Cost of Pods sold Cash Depreciation interest expense Selling & Administrative Accounts payable Fixed assets Sales Accounts receivable Notes payable Long-term debe Inventory New equity 2018 2019 224,3594 283 281 32,3721 34,394 63,334 71,584 13,783 15.780 44,121 57.580 57.220 63,479 279,419 348.500 440,122 $36,483 22,939 29,755 26,079 28.474 141.040 158,368 48.272 66.244 27.157 Ruby Co. currently pays out 50 percent of net income as dividends to Khaled and other original investors and has a 21 percent tax rate. You are working with Fatima, and she asked you to prepare the following: 1. Income statement for 2018 and 2019. (4 marks) 2. A balance sheet for 2018 and 2019. (4 marks) 3. Operating cash flow for 2018 and 2019. (2 marks) 4. Cash flow from assets for 2019. (2 marks) s. Cash flow to creditors for 2019. (2 marks) 6. Cash flow to stockholders for 2019. (2 marks) 7. After preparing all of these requirements, Fatima has asked you to describe cash flow for the company in 2019? Write your opinion. (2 marks) & Also, based on your analysis she asked you: what do you think about the expansion decision taken by Khaled? (1 marks) .. Why is the interest paid is not a component of the operating cash flow? / marks) Write down all the references you used in your answers. Submit excel file only. Ruby Co. is a small company that manufactures and sells silk carpets in Abu Dhabi. The found of this company is Khaled Saeed, and he is in charge of the design and sale of the carpets, but his background is only in making silk carpets, not business. As a result, the company's financial records are not well maintained. The initial investment in Ruby Co. was provided by Khaled and his family. Because the initial investment was relatively small, and the company has made carpets only for its own store, the investors haven't required detailed financial statements from Khaled. However, because the quality of the carpets is very good, sales of the carpets have increased rapidly in the recent months and Khaled is considering a major expansion. His plans include opening another store in Dubai, as well as selling his carpets to other customers in Saudi Arabia. Khaled's expansion plans require a significant investment, which he plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. The new investors and banks require Khaled to provide them with more organized and detailed financial statements than he has previously prepared. In order to do that, he hired a financial analyst, her name is Fatima (she holds a bachelor degree in finance from ADU University). He asked Fatima to evaluate the performance of the company over the past year. After going through all the bank statements, sales receipts, tax returns, and other records, Fatima has assembled the following information: IS 2018 2012 Cost of goods sold 224,359 $ 283,281 Cash 32,3721 34,394 Depreciation 63,334 71,584 Interest expense 13,783 15,780 Selling & Administrative 44,121 57,586 Accounts payable 57.2201 63,479 Fixed assets 279,419 348,508 Sales 440,122 536,483 Accounts receivable 22,939 29.755 Notes payable 26,0791 28,474 Long-term debt 141,040 158,368 Inventory 48,2721 66,244 New equity 27,157 Ruby Co. currently pays out 50 percent of net income as dividends to Khaled and other original investors and has a 21 percent tax rate. You are working with Fatima, and she asked you to prepare the following: 1. Income statement for 2018 and 2019. (4 marks) 2. A balance sheet for 2018 and 2019. (4 marks) 3. Operating cash flow for 2018 and 2019. (2 marks) 4. Cash flow from assets for 2019. (2 marks) 5. Cash flow to creditors for 2019. (2 marks) 6. Cash flow to stockholders for 2019. (2 marks) 7. After preparing all of these requirements, Fatima has asked you to describe cash flow for the company in 2019? Write your opinion. (2 marks) 8. Also, based on your analysis she asked you: what do you think about the expansion decision taken by Khaled? (1 marks) 9. Why is the interest paid is not a component of the operating cash flow? 1 marks)