Date 1-Jun 1-Jul 1-Aug 1-Sep 1-Oct 1-Sep Cash Inflow ($ received) 97 3,483 20,975 107,235 Cash Outflow ($ expended) 100 3,584 11,579 83,324 27,908 288 Net cash flow for month (100) (11,482) (79,841) (6,933) 106,947 Cash Position (Overdraft)

Direction: Define, draw the cash flow diagram, and write the general formula of the following: ANNUITY 1. Ordinary Annuity a) Sum/Future of Ordinary Annuity b) Present Worth of Ordinary Annuity 2. Annuity Due 3. Deferred Annuity

Assets Cash Receivables (net) Inventory PP & E (net) Patents&Licenses Goodwill Total assets Liabilities & Equity Accounts payable Short term debt Long term debt Preferred stock Common Equity Total Liabilities + Equity New Chip Corp Balance Sheet at 12/31/22 ($ in Millions) 31 45 64 215 28 19 402 53 19 179 23 128 402

Distribution lines on a journal entry are also shown on the Statement of Cash Flows. True or False

Please solve using Excel and show formulas. You have decided to buy a car with price tag of $60,000 but you are able to negotiate the price down to $58,000.  You have $5,000 saved, so you need to borrow $53,000 in a 5-year loan from your bank (your bank offers lower rates than the auto-dealer) at a 4.5% APR (annual rate). How much will you owe to the bank after 3 years?

Consider the following cash flows:   Year Cash Flow 0   –$ 32,500    1     14,300    2     17,400    3     11,700        What is the IRR of the cash flows? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

What is the IRR of the following set of cash flows? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Year 0 -~3 1 2 IRR Cash Flow -$ 16,900 7,600 8,900 7,400 %

3.

Can you please write the calculations step by step including the formulas. How did you calculate the Cash flow in order to calculate the cumulative cash flow after that?

What is the IRR of the following set of cash flows? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Year 0 1 2 23 IRR Cash Flow -$ 16,600 7,300 8,600 7,100 %