can u help me this formulas and how to calculate cash flows
G % Return A c 4 Correct answers are green, others are amber. When complete, save the spreadsheet and upload it to Blackboard. D 5 6 Problem Purchase Change in Price Sale Price Cash Flows Wealth 7 1. Purchased shoes for $20 at a thrift shop: sold them for $40 on eBay 20.00 40.00 3 2. Invested $10,000 in the stock market, the current value is $11,000. 10,000.00 11,000.00 9 3. Bought a computer for $300 sold on Craigs list for $400. 800.00 400.00 10 4. Deposited $1,000 in a savings account; earned $20 interest 1.000.00 1.000.00 5. Spent $100 on groceries. A power failure means they all spoilt 11 100.00 0.00 12 6. Bought an apartment for $200,000. Eamed $40,000 in rent. Sold it for $300,000 200,000.00 300,000.00 13 7. Invested $50,000 in a high-yield bond, samed 5,000 interest, sold it for $40,000 50,000.00 40,000.00 8. Invested $25,000 in the stock market. Earned $1,000 cash dividends. The investment is now worth 14 534,000 25,000.00 34,000.00 -15 2. LUX UU. cau. Pra Vale nen 500.00 500.00 10. Invested $10,000 in a small business. In year 3, the investment is worth $100,000. In Year 6, it is 16 worth $1,000,000. In Year 10 it goes bankrupt and is worth zero. It never paid a dividend 10,000.00 0.00 17 11. All's English professor grades based on a weighted average of quizzes (30%), essays (40%) participation (10%) and final exam (20%). His quiz average was 90%, essay average was 80% Enter your formula here 18 participation (100%, and final exam 95% What was his weighted average grade! 19 12. Tyrique car sold 100 pairs of Addidas Yeezy's for $30,000, having bought them all four weeks ago Enter your formula here> 20 for $25,000. What was his annual return? 21 22 23 24 1 Holding Period Putum Assignment Worksheet 2 SCORE 02 Directions Enter the correct values incolumns Band and the correct formulas in D, E, and Correct answers and green, others are amber. When complete, save the spreadsheet and upload it to Blackboard, Purchase Changin Sale Price Can Flow Weil Price Ritum 20.00 1000 10,000.00 11.00000 800.00 400.00 1.000.00 1.000.00 - Problem 1. Purchased for $20 tarif she wild them for 540 on eBay. 2. lived 510,000 in the state the current value is $11.000 3. Bought a computer for 5800, sold on Chips list to $400 4.Deported 51,000 in a swing count turned $20 interelt 10 5 Sout $100 on prooires A power tale mets they al 90 11 6 Bought in curtment for $200,000. Caned $40.000 in tert. Sold to $300,000 7. Invested 50.000 in a high yield bond, caned $5,000 interest, vidit tu$40.000 inted 525.000 in the market. Eanod 5.000 cash didends. The livestreant is now worth 16534000 www.www. 10. heted 510.000 hava besh yr 3, the investment is worth $100,000. in Y6, it's 1 worth $1,000,000. In Your 10 per bankrupt and is worth more. I never put a dvound 100.00 0.00 200.000,00 200.000.00 13 50,000.00 40,000.00 25,000.00 34.000.00 500.00 500.00 10,000.00 0.00 11. All English profesorades and on weighted at o quizzei (30 euy (408) partiction (10% and in 2012 sur eng as 90%, may wis 80% participation (100%, and final scan 95%. What was huwagto serage rate! Enter your form her 12 Trout en sit 100 and Addin Yaylor 530.000, twing brought them at four weeks ago Enter your formule 20 22 point 9. Bought a bycycle for $500. earned $2000 delivering for postmates. paid $500 in taxes. Sold the bike for $500