Need help getting started with formulas I will do the rest (aka inputting them into excel with the correct cell block), completely lost. Please help by showing the correct formulas so I can implement them for this assignment and future ones. Thank you

W\&S Partners has just won the January 31,2026 , audit for Cloud 9. As a part of the risk assessment phase for the new audit, the audit team needs to gain an understanding of Cloud 9's structure and its business environment, determine materiality, and assess the risk of material misstatement. This will assist the team in developing an audit strategy and designing the nature, extent, and timing of audit procedures. The trial balance at October 31,2025 is provided here. design procedures to identify and correct errors or irregularities that would have a material effect on the financial statements and affect the decision-making of the users of the financial statements. Materiality is used in determining statements and affect the decision-making of the users of the financial statements. Materiality is used in determining audit procedures and sample selections, and evaluating differences from client records to audit results. Materiality is the maximum amount of misstatement, individually or in aggregate, that can be accepted in the financial statements. In selecting the benchmark to be used to calculate materiality, the auditors should consider the key drivers of the business. They should ask, "What are the end users (that is, stockholders, banks, etc.) of the accounts going to be looking at?" For example, will stockholders be interested in profit figures that can be used to pay dividends and increase share price? W\&S Partners' audit methodology dictates that one planning materiality (PM) amount is to be used for the financial statements as a whole. The benchmark selected for determining materiality is the one determined to be the key driver of the business. W\&S Partners uses the following percentages as starting points for the various benchmarks: These starting points can be increased or decreased by taking into account qualitative client factors, which could be: - The nature of the client's business and industry (for example, rapidly changing, either through growth or downsizing, or an unstable environment). Whether the client is a public company (or a subsidiary of a public company) subject to regulations. The knowledge of or high risk of fraud. Typically, income before tax is used; however, it cannot be used if reporting a loss for the year or if profitability is not consistent. When calculating PM based on interim figures, it may be necessary to annualize the results. This allows the auditors to plan the audit properly based on an approximate projected year-end balance. Then, at year-end, the figure is adjusted, if necessary, to reflect the actual results. Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. Using the October 31, 2025 trial balance, calculate planning materiality based on income before tax