Answer/complete the following questions or tasks:

Put together an income statement, including EBITDA, for the company and each channel.Provide your P&L(s), and also answer the questions below:

(1)What was the fee income for Channel 3?

(2)What was the total revenue for Channel 2?

(3)Which channel had the most commissions?For this channel, calculate it's % of total company revenue and commissions.Do you have any observations on these numbers?

(4)What is the Net Income of Channel 4?Based on your answer, do you have any observations about this channel?

(5)What is the EBITDA of Channel 2?

(6)Based on your observations about Channel 1, do the leads cost make sense?Why?

6:25 Files Trial Balance I Q E . . . Trial Balance by Channel 202101 Period Company ID Account Type Account Account Description Total Company Channel 1 Channel 2 Channel 3 Channel 4 Channel 5 202101 222 401010 ain (loss) on Sale of Residen 202101 222 401020 Change In FMV - In -$23,45 $23 458 202101 222 401030 Change In FMV - Residential Mo $3,261 "$3.261 202101 222 401040 Hedge Costs & Pair Off Fees $184,316 $184,316 202101 222 401060 Branch Margin $145,312 $14,228 .$5 -$159,638 202101 222 $104 401070 Brokered Loan Allocation $2,38 $2,269 $119 202101 222 401071 Broker Loans FAR $3,056 $3,605 202101 222 401072 Broker Loans $275 349 202101 222 401090 Investor Fees EPO EPD -$329 -$120 -$20 -$47 202101 222 401100 Gain/Loss $1,190 $6,96 -$8,679 202101 222 401120 Pricing Margin 82,237 $6,246 $20,581 $109,064 202101 222 401140 Volume Incentives -$24 222 401160 202101 222 401180 Secondary P&L $51,978 $60 179 $51,978 $60.179 222 401250 Capitalized Se $82,271 $82,271 202101 222 401251 222 Issue Income $9,276 $9,276 202101 401260 MTM Change In MSR Hedge $96,735 202101 222 $96,735 401270 Provision for Re $915 -$3,432 -$624 $6.600 202101 222 401340 Concessions $36,643 $43.97 $4,014 "$3 313 202101 222 401345 Corporate Concessions $43,97 202101 222 401350 Net Buy Expenses -$15,45 -$15,456 TOTZOZ 222 440040 Interest Inc: LHFS $14,092 222 514,092 451010 Interest Inc: Other $563 $563 02101 222 Loan Origination Fees $1,620 $1,619 $1 -02101 222 451030 Credit Report Fee Income $1,637 $1,295 $338 TOTZO 222 451040 Doc Prep Fee - Income $1 202101 451050 Loan Admin Fees $14,18 $13,010 $895 $279 :02101 451070 Loan Processing Fees $8,156 $8,141 $57 02101 222 451080 $111 $229 -$56 -$49 Other Fee Income $50 -$16 02101 222 451110 $8,201 $4,790 $3,411 02101 222 451120 Appraisal Fee Income $4,793 $4,612 $50 202101 222 $117 501010 Regular Wages -$38,444 -$22,142 $2,534 -$4,849 $5,77 202101 507020 Overtime -$1,923 -$406 -$981 $3,147 222 -$4,515 -$931 -$274 TOIZO 222 501030 Holiday Pay 02101 222 501040 Personal Time Pay -$1,45 -$581 -$154 -$263 -$351 -$109 202101 222 501050 -$523 $412 -$14 -$46 222 Temporary Employees 501060 Unpaid Net Branch Profit -$3,78 -$3,784 02101 222 501090 Bonuses & Incentives $27,563 -$23,780 -$634 $1,312 $1,218 -$618 02101 222 501100 401k Employer Match 501120 -$2,536 -$2,079 -$218 -$239 202101 02101 222 501145 ommissions -$71,079 -$68,271 -$2,795 -$13 npensation - Intercompany $3,388 02101 222 501146 Compensation 1/C (Salary) -31084 -$742 -$342 20210 501147 Compensation 1/C Bonus $373 -$373 20210 222 501210 Residual Bonus -$9,858 -$8,574 -$1,196 -587 20210 501250 Production Overrides -$17,58 $15,991 -$1,177 222 $299 20210 501260 Employer FICA Tax -$9,310 -$7,104 -$515 -$121 $603 -$560 -$528 02101 Employer FUTA Tax -$14 -$43 -$27 02101 22 501280 Employer SUTA Tax -$362 501290 Health Insuran -53.73 -$2,705 -$271 -$219 - $376 -$161 501320 Employee Seminars\\ Training -676 -52 -$15 02101 222 502005 842 Lease Expense - Operating -$3,42 -$3,42 20210 22 502009 Lease Imapirment - Operating -$578 02101 502010 Rent Expense -$3,213 -$26 20210 -$33 -$142 $2,821 502011 Facility Property Taxes -$5 -$1 02101 22 502014 Facilities: Cleaning -$37 20210 -$14 502015 Facilities: Other -$8 30 502020 202101 222 CAM Expenses - Rents -$124 -$111 EOTS 502100 Equipment Rental - $150 -59 -$105 -$115 02101 222 502180 Operating Expense -342 -$39 SO -$1 02101 222 502190 Real Estate Taxes -$25 -$21 So -$1 202101 502200 202101 222 502220 Utilities -$85 -$1 Relocation Expenses 202101 222 222 502230 Repairs & Mainter -$37 -$1 -$2 -$40 -$8 202101 511010 Advertising $1,541 -$1,504 202101 222 511380 Marketing -$2,294 -$803 -$616 -$42 -$19 -$814 202101 222 511390 Mortgage leads $2, 199 -$433 1,76 02101 222 511480 Event/Conference/Tradeshow so TOTZO 222 512010 Appraisal Expense $4,827 -$4, 047 -$50 -$96 -$11 $623 02101 222 512070 Broker Fees -$495 202101 222 512120 Contract Quality Control Servs -$701 02101 222 512130 Contract Underwriting Expense -$878 -$210 202101 222 512140 Credit Report Expense -$3,818 -$319 -$1,836 - $438 -$1,44 02101 222 512160 ent Prep/Commitment Fees -$89 -$230 02101 222 512190 Flood Certification In -$140 202101 222 512200 Inspection Fee Expense $33 -$3 -$7 202101 222 512280 Miscellaneous $73 $17 202101 222 512310 Notary Fee -$1 202101 222 512371 TRID Cures -$403 $243 -$40 202101 222 -$3 512420 Recording Fees -$409 202101 222 512470 Service Fee Expense -$2,025 so -$2,025 202101 222 512480 Service Fee Income $828 202101 222 51252 Verification Service Ex -$1, 360 $341 513020 ICMS Allocation - 8348 -$255 -$453 202101 222 -$2,46 -$4 -$4,464 $1,90 $1,66 -$544 202101 222 513100 Co-Issue and Boarding Fees -$776 $776 TOTZO 222 514050 Misc. Outside/Contract Srv $1,14 -$5 $717 202101 222 -$7 - $302 $3 -$122 51408 Professional Fees 202101 222 514085 Shared Serv Interco-Prof Fees -$421 -$44 -$49 202101 $278 222 514120 Professional Fees - Legal $114 rotz0 222 514150 Recruiting Costs :02101 51502 Amortization Software Licenses 3489 -$44 02101 222 $15030 Amortization - Intangible Asse 02101 222 515050 Deprecia -$197 -$161 02101 222 51506 02101 222 ciation - Equipment -$454 Depreciation - Furniture & Fix -$35 02101 222 Depreciation - Leasehold Impro -$29 -$21 -$4 515090 -36 202101 222 516020 Computer Services -$941 -$772 02101 222 516030 Software Expense $2,00 $1,428 $136 222 516070 Software Maintenance & Support 202101 222 516090 Telephone & Communications -$451 -$99 02101 222 517020 Courier Service -$344 02101 222 -$76 $216 222 517030 Furniture\\ Fixtures\\ Equipment -$725 202101 517060 Office Expenses -$257 -$241 02101 222 517110 Office Supplies & Printing - $397 -$249 - $132 02101 222 517120 Postage -$21 -$11 20210 222 517180 Printing and Stationary 20210 517190 Dues & Subscriptions 20210 222 518010 eals & Entertainment -$296 20210 518030 Auto & Travel Expenses -$223 02101 518040 Car Svc/Mileage/Parking/Tolls -516 222 518050 Conventions -$300 02101 518060 Employee Bu -$203 -$1 222 -$65 518080 Travel - Airfare 519010 Dues\\Licenses Expense -$473 - $45 $10 -$1, 666 02101 20210 222 519020 Insurance Expense -$501 520060 Contributions -$31 92101 222 Customer Refunds -$24 -$2 - $69 20210 520180 -$207 $207 02101 22 Intercompany Allocations 520210 Miscellaneous - Other DWL -$39 -$9 20210 520220 Miscellaneous Taxes -$1 -$397 92101 222 520230 Off-Site Record Storage -$43 20210 520240 Other Expenses -315 - $15 02101 222 520420 Property Tax 222 520660 Branch Reserve - Write Off -$300 -$300 202101 540010 Bank Charges $1,527 222 -$1,527 540060 Interest Exp -$11,089 02101 222 540170 Interest Exp - Other 573 $73 02101 222 540320 Penalty/Interest Expense -$6 .$44 $0 -$4 -$14 Total $54,264 $49,607 $10,127 $2,053 -$11,948 $4,424 B U L A . . .6:26 Files Account Line Roll-up Section 10 Salaries & Overtime Salaries and Benefits Fixed Expense 501020 Salaries & Overtime Salaries and Benefits Fixed Expense 501030 Salaries & Overtime Fixed Expense 501040 s and Bene Salaries & Overtime aries and Bene Fixed Expense 501050 Temporary Labor aries and Fixed Expense 501100 Benefits Fixed Expense 501146 Other Personnel Expenses Fixed Expense 501260 Taxes Fixed Expense 501270 Takes Fixed Expense 501280 Taxes 501320 Other Personnel Expenses Fixed Expense 502005 Rent & Utilities uipment Rentals 502009 Rent & Utilities 502010 Rent & Utilities 502011 Rent & Utilities 502014 Rent & Utilities 502015 Rent & Utilities 502020 Rent & Utilities 502100 Furniture/Fixtures/Equipment 502180 Rent & Utilities 502190 Rent & Utilities 502200 Rent & Utilities 502220 Rent & Utilities ent Rentals Fixed Exper 502230 Furniture/Fixtures/Equipment ment Rentals 511010 Advertisement 511380 Other Marketing s Development 511390 Leads ess Developme Fixed Expense 511480 Other Marketing Iness Development Fixed Expens 513020 Global Operations Global Operations Fixed Expense 514050 Other Professional Fees Professional Fee Fixed Expense 514080 Other Professional Fees Professional Fe Fixed Expense 514085 Direct Bill Expense - Prof Professional Fee Fixed Expense 514120 Professional Fee 514150 Other Professional Fees Professional Fees Fixed Exper 515020 Software Expense Occupancy and Equip Equipment Rentals 515030 Amortization Depreciation and Amortization Fixed Expense 515050 Depreciation Depreciation and Amortization Fixed Expense 515060 Depreciation reciation and Amortization Fixed Expense OCOSTS preciation and Amortization Fixed Expense 515090 Depreciation reciation and Amortization 516020 Telephone & Communications munication and Data Processing Fix 516030 itware Expense 516070 Occupancy and Equipment Rentals Fixed Expens oftware Expense pancy and Equipment Rentals Fixed Expens 516090 Telephone & Communications Communication and Data Processing Fixed Expense 517020 Postage & Delivery Office Expense Fixed Expense 517030 Furniture/Fixtures/Equipment Occupancy and Equipment Rentals Fixed Expense 517060 Other Office Expense Office Expense Fixed Expense 517110 Office Supplies Office Expense Fixed Expense 517120 Postage & Delivery ffice Exper 517180 Printing & Stationary Fixed Expense 517190 Other Office Expense Fixed Expense 518010 Meals & Entertainment Travel and Entertainment Fixed Expense 518030 Auto Expense Travel and Entertainment Fixed Expense 518040 Auto Expense Travel and Entertainment Fixed Expense 518050 Meals & Entertainment Travel and Entertainment 518060 Travel Expense Travel and Entertainment Travel Expense Travel and Entertainment 519010 License & Fees Other Expense Fixed Expens 519020 Insurance Other Expen Fixed Expense 520060 Miscellaneous (Income)/ Expense Other Expense Fixed Expense 520070 Miscellaneous (Income)/Expense Other Expen Fixed Expense 520210 Miscellaneous (Income)/Expense Other Expen Fixed Expense 520420 License & Fees Fixed Expense 520230 Miscellaneous (Income)/Expense Fixed Expense 520240 Direct Bill Expense - Other Fixed Expense 520420 Rent & Utilities Occupancy and Equipment Rentals Fixed Expense 520660 Branch Reserve Other Expense Fixed Expense 401010 Day 1 Pricing Margin Gain on Mortgage Loans Revenue 401020 Day 1 Pricing Margin Gain on Mortgage Loan Revenue 401030 Day 1 Pricing Margin Gain on Mortgage Loan Revenue 401040 Day 1 Pricing Margin Gain on Mortgage Loan Revenue Day 1 Pricing Margin Gain on Mortgage Loans 401070 Brokered Income red Income 401071 Brokered Income Brokered Income 401072 Brokered Income Brokered Income Revenue 401090 Other Day 2 Income/(Expense) Other Day 2 Income/(Expense) 401100 Other Day 2 Income/(Expense) Other Day 2 Income/(Expense) 401120 Day 1 Pricing Margin Gain on Mortgage Loans 401140 Day 1 Pricing Marg Gain on Mortgage Loans 401160 Day 1 Pricing Margin Gain on Mortgage Loans 401180 Capital Markets Gains/(Losses) Capital Markets Gains/(Losses) 401250 Day 1 Pricing Margin 401251 Gain on Mortgage Loans 401360 Day 1 Pricing Margin Gain on Mortgage Loans Revenu Day 1 Pricing Margin Gain on Mortgage Loans 401340 Less: Concessions Gain on Mortgage Loans Revenue Other Day 2 Income/(Expense) Other Day 2 Income/(Expense) Revenue Day 1 Pricing Margin Gain on Mortgage Loans Interest Income Net Interest Income Revenue terest Income Net Interest Income Revenue 451010 ender Fees (paid by borrow Fee Income Revenue 451030 ender Fees (paid by borrowe Fee Income Revenue 451050 er Fees (paid by borrow Fee Income Revenue 451070 Lender Fees (paid by borrowe Fee Income evenue 451080 Lender Fees (paid by borrower Fee Income 451110 Fees (paid by borrow 451120 Lender Fees (paid by borrower) 513100 Other Day 2 Income/(Expense) Other Day 2 Income/(Expense) 540010 Bank Service Fees Net Interest Inco Revenu 540060 Interest Expense Net Interest Incon Interest Expense Net Interest Income Revenue 401270 Provision for Loan Losses Provision for Loan Losses Variable Expense 451040 Misc Loan Fees Loan Origination Expenses Variable Expense 501060 Other Branch Compensation Variable Exp 501090 Bonuses & Overrides ariable Exp 501120 Commissions 501145 Commissions 501147 Bonuses & Overrides 501210 Bonuses & Overrides 501250 Bonuses & Overrides Variable Compensa Variable Expense 512010 Misc Loan Fees Loan Origination Ex Variable Expense 512070 Isc Loan F Variable Exp 512120 ic Loan Fe 512130 Misc Loan Fe 512140 Misc Loan Fees 512160 MIsc Loan Fees 512190 MIsc Loan Fees 512200 MIsc Loan Fee Variable Exp Variable Expense 512280 MIsc Loan Fee Variable Expense 512310 Variable Expense 51237 51242 Misc Loan Fees Recording Fee Loan Origin 512470 MIsc Loan Fees Loan Originat Variable Expen 51248 Loan Origination Expen Variable Expense 51252 Misc Loan Fees Loan Origination Expen Variable Expense $20180 Misc Loan Fees Loan Origination Expenses Variable Expense 540320 Provision for Loan Losses Provision for Loan Losses Variable Expense =