U.S. Census Bureau statistics show that the annual earnings for persons with a high school diploma are $35, 220 versus $57, 925 for someone with a bachelor’s degree. If the cost of attending college is assumed to be $35, 000 per year for 4 years and the forgone earnings during those years are assumed to be $35, 220 per year, what rate of return does earning a bachelor’s degree represent? Use a 25-year study period. In your analysis, you are expected to: (i) Use Excel to display the cash flow; (ii) Draw a Cash Flow Diagram; (iii) Use Excel to compute the internal rate of return of the CFD. (Hint: The investment in years 1 through 4 is the cost of college plus the foregone earnings, and the income in years 5 through 25 is the difference in income between a high school diploma and a bachelor’s degree.) Use excel

DRAW ALL CASH FLOW DIAGRAMS 1. Barbara wants to triple the money currently in her account that earns 3.5% per year interest. How long does she need to wait? 2. Joe deposits S8,000 right now and another $3,000 5 years from now. How much money will be in the account 12 years from now? Rate is 4% per year 3. Joe (the same one above) deposits $8,000 now and withdraws $3,000 5 years from now. How much money will be in the account 12 years from now? 4. Jane deposits $2,500 into an account that carns 4.5% per year. 3 years later, the interest rate goes up to 6.5% How much money she will have 8 years after the initial investment? 5. Tim starts his freshman year and would like to take a trip to Europe upon graduation that will cost $5,600. How much he should be saving every year, including his senior year to be able to afford this trip. His bank account earns 4.5% per year interest.

Please no written by hand

Jim Smith is considering purchasing a new car. The price of the car is $51000, and Jim hopes to keep it 6 years and then sell it for $12500. Based on past experience, Jim drives about 20,000 km per year and lives in a downtown K apartment where they must pay a $22 per month parking fee. Jim has budgeted the following automobile expense items for the next 6 years: Expense Gasoline(10.5L Per 100KM) ($1.96 Per Liter) Licence/Registration Insurance Maintenance Tires ($1332 per set that last 70000KM) Parking (72 Months) Interest Depreciation (STRAIGHT LINE) Cost Fixed/Variable Variable $754 Fixed $5445 Fixed $6000 Variable Variable $1584 $3670 Fixed Fixed CALCULATE THE FOLLOWING USING THE ABOVE INFORMATION: TOTAL FIXED COSTS (TFC) TOTAL KMS TOTAL VARIABLE COSTS (TVC) TOTAL COSTS (TC) AVG. FIXED COSTS/KM AVG. VARIABLE COSTS/KM AVG. TOTAL COSTS/KM Fixed 120000KM