Appendix I$-$ Trial Balance Extract

Amount in CAD

Sr$.$No Name of the account $202320222021$

$1$ Rent $ $18,150\mathrm{.}00$ $ $16,500\mathrm{.}00$ $ $5,000\mathrm{.}00$

$2$ Bank Acc $ $10,800\mathrm{.}00$ $ $45,000\mathrm{.}00$ $ $12,000\mathrm{.}00$

$3$ Inventory $ $80,000\mathrm{.}00$ $ $149,150\mathrm{.}00$ $ $140,000\mathrm{.}00$

$4$ Repairs and Maintenance $ $10,000\mathrm{.}00$ $ $8,500\mathrm{.}00$ $ $6,000\mathrm{.}00$

$5$ Acc Payable $ $75,000\mathrm{.}00$ $ $28,500\mathrm{.}00$ $ $68,000\mathrm{.}00$

$6$ Amazon fees $ $210,000\mathrm{.}00$ $ $175,000\mathrm{.}00$ $ $100,000\mathrm{.}00$

$7$ Marketing expenses $ $12,500\mathrm{.}00$ $ $1,500\mathrm{.}00$ $ $2,000\mathrm{.}00$

$8$ Utilities $ $6,500\mathrm{.}00$ $ $3,000\mathrm{.}00$ $ $4,200\mathrm{.}00$

$9$ Accounts Receivable $ $40,000\mathrm{.}00$ $ $50,000\mathrm{.}00$ $ $10,500\mathrm{.}00$

$10$ Fixed Assets $ $218,000\mathrm{.}00$ $ $80,000\mathrm{.}00$ $ $45,000\mathrm{.}00$

$11$ Sale of a product $ $668,700\mathrm{.}00$ $ $565,000\mathrm{.}00$ $ $399,000\mathrm{.}00$

$12$ Cost of goods sold $ $220,000\mathrm{.}00$ $ $75,000\mathrm{.}00$ $ $60,000\mathrm{.}00$

$13$ Taxes Payable $ $-$ $ $13,400\mathrm{.}00$ $ $-$

$14$ Postage & Delivery $ $50,000\mathrm{.}00$ $ $25,700\mathrm{.}00$ $ $25,000\mathrm{.}00$

$15$ Dividend paid $ $(50,000\mathrm{.}00)$ $ $-$ $ $-$

$16$ Opening retained earnings $ $66,550\mathrm{.}00$ $ $36,400\mathrm{.}00$ $ $-$

$17$ Cash $ $5,500\mathrm{.}00$ $ $1,000\mathrm{.}00$ $ $-$

$18$ Accumulated Dep. on Fixed Assets $ $(60,000\mathrm{.}00)$ $ $(42,000\mathrm{.}00)$ $ $(22,500\mathrm{.}00)$

$19$ Wages $ $25,000\mathrm{.}00$ $ $15,000\mathrm{.}00$ $ $12,000\mathrm{.}00$

$20$ Dues & Subscriptions $ $22,000\mathrm{.}00$ $ $12,000\mathrm{.}00$ $ $18,000\mathrm{.}00$

$21$ Credit card o$/$s $ $14,600\mathrm{.}00$ $ $6,000\mathrm{.}00$ $ $27,000\mathrm{.}00$

$22$ Meals & entertainment expenses $ $13,000\mathrm{.}00$ $ $10,000\mathrm{.}00$ $ $8,000\mathrm{.}00$

$23$ Bank Charges $ $10,500\mathrm{.}00$ $ $2,500\mathrm{.}00$ $ $10,500\mathrm{.}00$

$24$ Office Supplies $ $2,500\mathrm{.}00$ $ $450\mathrm{.}00$ $ $800\mathrm{.}00$

$25$ Computer and Internet expenses $ $10,500\mathrm{.}00$ $ $1,500\mathrm{.}00$ $ $2,000\mathrm{.}00$

$26$ Telephone expense $ $11,000\mathrm{.}00$ $ $8,000\mathrm{.}00$ $ $5,500\mathrm{.}00$

$27$ Prepaid expenses $ $2,500\mathrm{.}00$ $ $2,500\mathrm{.}00$ $ $-$

$28$ Business license and permit $ $3,200\mathrm{.}00$ $ $3,200\mathrm{.}00$ $ $3,200\mathrm{.}00$

$29$ Travel Expense $ $25,600\mathrm{.}00$ $ $15,000\mathrm{.}00$ $ $18,000\mathrm{.}00$

$30$ Professional Fees $ $20,000\mathrm{.}00$ $ $16,500\mathrm{.}00$ $ $14,000\mathrm{.}00$

$31$ Automobile Expense $ $2,900\mathrm{.}00$ $ $3,000\mathrm{.}00$ $ $4,500\mathrm{.}00$

$32$ Other Income $ $42,750\mathrm{.}00$ $ $15,000\mathrm{.}00$ $ $10,000\mathrm{.}00$

$9$

$33$ Common shares $ $100\mathrm{.}00$ $ $100\mathrm{.}00$ $ $100\mathrm{.}00$

$34$ Insurance expense $ $30,000\mathrm{.}00$ $ $22,500\mathrm{.}00$ $ $18,900\mathrm{.}00$

$35$ Advertising expense $ $48,000\mathrm{.}00$ $ $35,000\mathrm{.}00$ $ $55,000\mathrm{.}00$

$36$ Loan from shareholder $ $93,450\mathrm{.}00$ $ $41,100\mathrm{.}00$ $ $35,500\mathrm{.}00$

$37$ Accrued Liabilities $ $42,000\mathrm{.}00$ $ $35,000\mathrm{.}00$ $ $23,000\mathrm{.}00$

$38$ Security deposit $ $5,000\mathrm{.}00$ $ $5,000\mathrm{.}00$ $ $5,000\mathrm{.}00$

Appendix II

Product Modification Project $ $100,000\mathrm{.}00$

Expected benefits $4$ years

Year Incremental Revenue Cost of Maintenance

$158,00020,100$

$253,00017,300$

$331,00014,200$

$440,50010,800$

Jeffry is collaborating with independent racers in the targeted cities to

promote the PPI products & bring awareness to the audience. The sales manager

believes that with this strategy, the corporation could generate sales from South

American countries of approximately $$120,000($annually$?$ Monthly? Quarterly?$).$

The plan is to hire $5$ racers, one each in Columbia, Mexico, Peru, Chile, and Brazil.

The average fee for each racer is estimated to be $$1,500$ a month. For now, it can be

estimated for the next five

years that the sales each

year will increase by $15\%$

in these countries with a

relative increase in the

cost by $10\%.$

Using the historical data,

marketing strategy, product

modification project analysis,

and ratio analysis, Jeffry wants

to prepare a master budget on a

total basis, $($a per unit budget is

not required$)$ for the next two

years with budgeted financial

statements.

can you please answer the above given questions with data and prepare all the answers in detail with financial statements, master budget, ratio anaylysis, cash flow prepration and other questions mentioned above.