1. David and Connor form a partnership with initial investments of $200,000 and $400,000, respectively. Their partnership agreement includes a salary to David for $40,000 and to Connor for $60,000. Each partner is also to receive 10% interest on their initial investment, with any remaining income to be divided equally. Using an excel spreadsheet, prepare a schedule showing the distribution of $150,000 in net income.