need excel formulas for areas in green

A X Cut Arial ViA VA A Copy 2 Wrap Text Merge & Center - Paste $ % BIU- . Format Painter Aronment Number Clipboard # 05.- B20 -- Time Value Challenger - Lump Sums Complete each of the questions following all instructions given You may use formulas or Excel Time Value Functions Your small business has the following income statement for 2018 - Revenues Cost of Goods Sold Gross profit 252050 114,987 137,063 Operating expenses Earnings before taxes Income taxes Net income 72,906 64,157 15,398 48.7591 You are trying to estimate your business Net Income for 2023, but your Reveues and expenses are increasing at different rates What will your net Income be in 2023 assuming the following annual growth rates? 50% Revenues Cost of Goods Sold Operating expenses Years to 2023 Tax Rate 24% ARS NEAR Revenues Cost of Goods Sold Gross profit Do not round any of your calculations Operating expenses Earnings before taxes Income taxes Net income student name main Accessibility investigate Ready Start a search Lip Sum Challenger - becel Amber Champou ower Pivot Tell me what you want to do Conditions Formatting Table Delete Format Edong KLMN0 You win a local lottery that will pay you the following payment for 3 years beginning one year from today What is the present value of that stream of payments assuming the given discount rate? Annual Payment Discount rate 25,000 25% Hint Teata lump Present Value You have the following current and desired savings balances. You would Ike to have the desired balance at the time you retire 40 years from now. What rate would you need to earn on your current balance in order to achieve your goal? Current Balance Desired Balance Years to retirement 125.000 750.000 Required rate: Your father tell you that he started with the following amount of savings at age 21, and retired with the following amount after earning the given rate on his savings over those years. Your father would never tell you his age- can you figure it out? Age when savings were deposited Starting Balance Ending Balance Rate oamed Years since retirement 21 50,000 750 000 50%