We are to use Microsoft Excel to solve this question and open the day books aswell

17.3 You are to open the books of F. Polk, a trader, via the journal to record the assets and liabili ties, and are then to record the dialy transactions for the month of May. A trial balance is to be extracted as on 31 May 2017. 2017 May 1 Assets: Premises f34,000; Van f5, 125; Fixtures f810; Inventory f6,390; Accounts receivable: P. Mullen f140, F. Lane f310; Cash at bank f6,240; Cash in hand $560. Liabilities: Accounts payable: S. Hood f215, J Brown f640. 1 Paid storage costs by cheque f40. 2 Goods bought on credit from: S. Hood f145; D. Main E206; W. Tone 196; R. Foot E66. 3 Goods sold on credit to: J. Wilson f112; T. Cole f164; F. Syme f208; J. Allen 191; P. White f242; F. Lane 190. 4 Paid for motor expenses in cash f60. 7 Cash drawings by proprietor f150. 9 Goods sold on credit to: T. Cole f68; J. Fox f131. 11 Goods returned to Polk by: J. Wilson f32; F. Syme E48. 14 Bought another van on credit from Abel Motors Ltd f4,850. 16 The following paid Polk their accounts by cheque less 5 per cent cash discount: P. Mullen; F. Lane; J. Wilson; F. Syme. 19 Goods returned by Polk to R. Foot f6. 22 Goods bought on credit from: L. Mole f183; W. Wright f191. 24 The following accounts were settled by Polk by cheque less 5 per cent cash discount: S. Hood; J. Brown; R. Foot. 27 Salaries paid by cheque f740. 30 Paid business rates by cheque f140. 31 Paid Abel Motors Led a cheque for $4,850. 213