Summary: 1. Use the attached Excel template to submit yourassignment. When I said do not make any changes I means do not add, delete,move any rows or columns. Norr and Caylor established a partnership on January 1, 2019. Norr invested cash of $100,000 and Caylor invested $30,000 in cash and equipment with a book value of $40,000 and fair value of $50,000. For both partners, the beginning capital balance was to equal the initial investment. Norr and Caylor agreed to the following procedure for sharing profits and losses: 12% interest on the yearly beginning capital balance $10 per hour of work that can be billed to the partnership's clients the remainder divided in a 3:2 ratio The Articles of Partnership specified that each partner should withdraw no more than $1,000 per month, which is accounted as direct reduction of that partner's capital balance. For 2019, the partnership's income was $70,000. Norr had 1,000 billable hours, and Caylor worked 1,400 billable hours. In 2020, the partnership's income was $24,000, and Norr and Caylor worked 800 and 1,200 billable hours respectively. Each partner withdrew $1,000 per month throughout 2019 and 2020. Complete the following: Determine the amount of net income allocated to each partner for 2019. Determine the balance in both capital accounts at the end of 2019. Determine the amount of net income allocated to each partner for 2020. (Round all calculations to the nearest whole dollar). . Determine the balance in both capital accounts at the end of 2020 to the nearest dollar. 3 4 Fill in the amount below. (Replace the ? Below) DO NOT MODIFY THE FORMAT OF THIS SPREADSHEET. (l.e. do not add or delete lines.) 5 (a) Amount of net income allocated to each partnership for 2019: 6 7 8 Interest Norr ? Caulor ? Total ? 9 Compensation ? ? ? 10 Remainder (60%, 40% split) ? ? ? 11 Net income allocated for 2019 ? ? ? 12 13 14 (b) Balance in both capital accounts at the end of 2019: 15 16 17 Beginning capital 2019 Norr ? Caulor Total ? ? 18 Net income allocated for 2019 ? ? ? 19 Withdrawal (1,000 x 12) ? ? ? 20 Ending capital balance 2019 ? ? ? 21 22 23 (a) Amount of net income allocated to each partnership for 2020: 24 25 Norr Caulor 26 Interest ? ? Total ? 27 Compensation ? ? ? 28 Remainder (loss) (60%, 40% split) ? ? ? 29 Net income allocated for 2020 ? ? ? 30 Note: Use minus to show loss. 31 32 (b) Balance in both capital accounts at the end of 2020: 33 34 Norr Caulor Total 35 Beginning capital ? ? ? 36 Net income allocated for 2020 ? ? ? 37 Withdrawal (1,000 x 12) ? ? ? 38 Ending capital balance 2020 ? ? ? 39 40 41 42 43