PLEASE ANSWER THE HIGHLIGHTED CELL (REQUIREMENT 1 RATIO ANALYSIS)

FINANCIAL STATEMENTS

Sarah Smith has requested that you analyze the statements using the ratios requested on the blue cells to the right. Your answers should be in the cells noted in blue. IMPORTANT: Do not make any changes to the financial statements below. VantagePoint Consulting Solutions Inc. Requirement \#1 - Ratio Analysis Statement of Income Please ensure you read the notes to the financial statements. Please calculate each of the following ratios for 2024 and 2025 . Answers must be in the blue cells For the year ended December 31 provided using formulas in Excel (do not use your calculator and input your final answer into Excel) Note 1: Management has determined that 80% of its sales were on credit in 2025 , and 90% in 2024. Sarah Smith has requested that you analyze the statements using the ratios requested on the blue cells to the right. Your answers should be in the cells noted in blue. IMPORTANT: Do not make any changes to the financial statements below. VantagePoint Consulting Solutions Inc. Requirement \#1 - Ratio Analysis Statement of Income Please ensure you read the notes to the financial statements. Please calculate each of the following ratios for 2024 and 2025 . Answers must be in the blue cells For the year ended December 31 provided using formulas in Excel (do not use your calculator and input your final answer into Excel) Note 1: Management has determined that 80% of its sales were on credit in 2025 , and 90% in 2024