Pemberton Performance Incorporation $($DBA$-$ PPI Bike$)$ At the heart of Pemberton, BC$,$ a unique partnership was formed between a chemist father and his downhill racer son. Together, they spotted a niche in the market for eco$-$friendly maintenance products that would benefit both cyclists and the environment. At PPI Bike, they craft highquality, bio$-$based bicycle maintenance products that strike a balance between performance and environmental responsibility. The company$$s products are free from petrochemicals, PTFEs, and harmful substances, ensuring the safety of cyclists and the preservation of our natural world. The range of products includes various bicycle products categorized into three main categories: cleaners, lubricants and suspension. $2$ PPI Bike was incorporated in the year $2021$ amidst COVID$-19$ when the demand to focus on exercise was on the rise, and people were prioritizing spending time on their health. This created an opportunity for the father$-$son duo to start their venture on high, and the corporation was doing great in the first two years. Due to an increase in demand and sales there was significant growth in the industry with new startups entering the market creating additional competition for PPI Bike. Amidst competition and increased cost and shortages in the supply chain came a new crisis in the industry as the world was going back to the pre$-$COVID scenario. It is now imperative for businesses to survive in a new space where competition is high, sales are not guaranteed and the company faces inflated cost of production. The son Jeffry Gates, is now taking the reins of the corporation as the new CEO. With the father focusing on new projects, Jeffry is poised to aggressively drive the growth of PPI Bike, sparking anticipation and excitement for what lies ahead. Jeffry doesn$$t have an in$-$depth background in finance & accounting is looking to seek some help from the MBA students to help him out with the queries. To begin with, Jeffry wants help with drafting a financial statement based on the trial balance extract available as per Appendix I. He isn$$t sure how to differentiate or understand asset, liabilities, expenses and income. In a conversation with him he noted that both rent expense paid and machinery purchased are one in the same as both transactions reduces the company$$s cash balance. He would appreciate any insight on these matters along with preparation of financial statements. Jeffry is looking to explore the South American market for expansion as the continent offers perfect weather for cycling activities, which in turn offers an additional customer base that is interested in bicycle products. As a part of the strategy, 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\%.$ Jeffry doesn$$t want to use existing funds in the bank account for this marketing strategy for the first year but is open to any other options, such as term loans, lines of credit or any other option. He is uncertain of their impact on the financial statements and cash position. Alternatively, the company can invest in a product modification project requiring an initial cash outflow of $$100,000.$ The incremental cash flows, as a result, are provided under Appendix II$.$ Jeffry needs clarification about investing in expansion or product modification projects. Jeffry was a mountain racer and now rides recreationally with friends and family. Some of his friends have business operations in Silicon Valley in the technology and finance sector. They suggested Jeffry consult a private equity fund if the business is not growing as expected. One of his friends referred him to the Avon Equity fund, where they offered to purchase his whole business for $1$ payment of USD $1$ million. Jeffry believes if we can show higher margins for the future years on the pitch deck to investors, the offer price may increase and he can get greater value out of it$.$ He is still determining the manipulation in the forecasted margin from the best ethical practice perspective. He is leaning to accept his friend$$s advice on equity funds and wants to understand how the business is doing based on the financial data we have and the industry standards available. To address This Photo by Unknown Author is licensed under CC BY$-$NC$-$ND $6$ the concern, he wants your team to perform a complete a ratio analysis and conclude on key metrics of profitability, liquidity and solvency.. After the analysis, he w