Question 1 Write down all ofyour personal assets and liabilities. These may not include assets which are your parents they will include loans your parents expect you to pay back (ie, tuition loans). Same for grandparents, siblings. et al. When in doubt leave off the asset put on the liability (assume you owe, but not own). Inheritance is not an asset (yet)--it does not get included. A full list of items to check for will be provided. Then write down your current income streams (if any) and write down your current outflow streams (they definitely exist). Form a zero-balance budget. Write down your assets and liabilities as a balance sheet (net worth is the same as equity). Write down your income and expenses as an income statement. Make the statements (balance sheet and income statement) common size Note: to common size for income statement divide it by sales/wages, to common size for balance sheet divide it by total assets or total liabilities and net worth (together). Submit ONE excel document with Balance sheet on one tab and income statement on the other. Analyze your current financial situation. Are you appropriately insured for health insurance. car insurance disability insurance. life insurance, etc, Are you underwater/fiscally bankrupt (owe more than you have) this is the case for the majority of you: do not fret What do you plan to do about it? Was this project eye opening? Submit a copy of your COMMON SIZE ONLY (CA) Balance sheet and Income Statement. You will receive a 25% reduction in your final grade for this quiz if yoiu submit dollar (S) figure numbers fors Question 2 Question4 Create an amortization table for a corporate bond which has a yield to maturity (YTM) of 3.66% that will last 30 years and has a coupon rate of 4%. Create an amortization table for a corporate bond which has a yield to maturity 20 years and has a coupon rate of 4%. of655% that will last Create an amortization table for a corporate bond which has a yield to maturity OTM) of 496 that will last 15 years and has a coupon rate of 4%. Upload ONE excel document with each bond on its own sheet (one bond per tab) 0 A list of items to check for e Checking Accounts e Savings Accounts . Certificates of Deposits Investment Funds . Private Loans MADE to friends and family . Car Value (use Kelley Blue Book) e Home value (if you own one) . Expensive Persoual Property (real gold jewellery, ete.) . Other personal assets (art if it has a marketable value) . Inherited Items which passed to you, but which your parents have re mained xuardinus of aud never discloerd to you your ownership in the item. - Credit Cards - Private Laans (Teneunl kaus frou friuds and family) . Bank Loams Auta Loans uculs il your ne without your ki B | r u , | A . . | , atx x, x . 1 LNermall 1 No Spac.. at Painter Heading 1 . Heading 2 Title Font Patagraph Styles My Questions content Problem N1 Assets Checking account 2300S Saving account 4500$ Expensive personal property: Jewelry 600os Other Personal assets: Apartment Furniture 5000s Student loan 25000S My Income streams 15009 My Outflow streams 1300$ Car Insurance 100$ Health Insurance 300S 173 words 2 w ) Type here to search ootnialNoSpa. Heading 1 Heading 2 Title Paragraph Styles NOTE related to problem N1: 1- Apart from loan I don't have debt 2- I'm an independent student nothing related to parents or other entity. 3-Please make sure to abide by the 25% reduction notice. Problem N2: The amount of mortgage that I can afford is 180000S to buy a house. Average prices for a house in Morgantown WV are 180000S I found a house that I would buy is in Fairmont Rd, Morgantown WV, Maple Grove by (Dyane Rayan Builders), prices average between 164000-198000s se Heading1 Heading2 Title nt Paragraph Styles Problem N3: I don't have Social Security, I'm planning to retire at 65 years old. My retirement plan should reach a ceiling of 3 million Dollars. Problem N4: 1-Please make sure that each assessment should be in a separate excel sheet 2 Please Follow carefully the instructions given! Thank you! Question 1 Write down all ofyour personal assets and liabilities. These may not include assets which are your parents they will include loans your parents expect you to pay back (ie, tuition loans). Same for grandparents, siblings. et al. When in doubt leave off the asset put on the liability (assume you owe, but not own). Inheritance is not an asset (yet)--it does not get included. A full list of items to check for will be provided. Then write down your current income streams (if any) and write down your current outflow streams (they definitely exist). Form a zero-balance budget. Write down your assets and liabilities as a balance sheet (net worth is the same as equity). Write down your income and expenses as an income statement. Make the statements (balance sheet and income statement) common size Note: to common size for income statement divide it by sales/wages, to common size for balance sheet divide it by total assets or total liabilities and net worth (together). Submit ONE excel document with Balance sheet on one tab and income statement on the other. Analyze your current financial situation. Are you appropriately insured for health insurance. car insurance disability insurance. life insurance, etc, Are you underwater/fiscally bankrupt (owe more than you have) this is the case for the majority of you: do not fret What do you plan to do about it? Was this project eye opening? Submit a copy of your COMMON SIZE ONLY (CA) Balance sheet and Income Statement. You will receive a 25% reduction in your final grade for this quiz if yoiu submit dollar (S) figure numbers fors Question 2 Question4 Create an amortization table for a corporate bond which has a yield to maturity (YTM) of 3.66% that will last 30 years and has a coupon rate of 4%. Create an amortization table for a corporate bond which has a yield to maturity 20 years and has a coupon rate of 4%. of655% that will last Create an amortization table for a corporate bond which has a yield to maturity OTM) of 496 that will last 15 years and has a coupon rate of 4%. Upload ONE excel document with each bond on its own sheet (one bond per tab) 0 A list of items to check for e Checking Accounts e Savings Accounts . Certificates of Deposits Investment Funds . Private Loans MADE to friends and family . Car Value (use Kelley Blue Book) e Home value (if you own one) . Expensive Persoual Property (real gold jewellery, ete.) . Other personal assets (art if it has a marketable value) . Inherited Items which passed to you, but which your parents have re mained xuardinus of aud never discloerd to you your ownership in the item. - Credit Cards - Private Laans (Teneunl kaus frou friuds and family) . Bank Loams Auta Loans uculs il your ne without your ki B | r u , | A . . | , atx x, x . 1 LNermall 1 No Spac.. at Painter Heading 1 . Heading 2 Title Font Patagraph Styles My Questions content Problem N1 Assets Checking account 2300S Saving account 4500$ Expensive personal property: Jewelry 600os Other Personal assets: Apartment Furniture 5000s Student loan 25000S My Income streams 15009 My Outflow streams 1300$ Car Insurance 100$ Health Insurance 300S 173 words 2 w ) Type here to search ootnialNoSpa. Heading 1 Heading 2 Title Paragraph Styles NOTE related to problem N1: 1- Apart from loan I don't have debt 2- I'm an independent student nothing related to parents or other entity. 3-Please make sure to abide by the 25% reduction notice. Problem N2: The amount of mortgage that I can afford is 180000S to buy a house. Average prices for a house in Morgantown WV are 180000S I found a house that I would buy is in Fairmont Rd, Morgantown WV, Maple Grove by (Dyane Rayan Builders), prices average between 164000-198000s se Heading1 Heading2 Title nt Paragraph Styles Problem N3: I don't have Social Security, I'm planning to retire at 65 years old. My retirement plan should reach a ceiling of 3 million Dollars. Problem N4: 1-Please make sure that each assessment should be in a separate excel sheet 2 Please Follow carefully the instructions given! Thank you