Create a personal balance sheet for your assets

Assignment Help Finance Basics
Reference no: EM13971544

Please complete and submit your homework on 2/18/16. Please show all work and computations in your Homework.

Makeup a realistic Spending Journal: Keep track of "Every Penny Counts" spending journal to record all spending habits for 30 days. Be sure to approximate the monthly costs and future income (starting salary for your job after college) and include them in the journal.

Personal Balance Sheet: Create a personal balance sheet for your assets, liabilities, and net worth.

Personal Cash Flow Statement: Use the information from your spending journal to help you create a personal cash flow statement with your total income, expenses and your net cash flow.

- These will most likely be turned in with a future HW journal submission (record 30 days).

Additional Problems:

1. Suppose you purchase 2 snacks on campus each day of the week for an average of $1.75 per purchase.
a) What is the daily cost?
b) What is the weekly cost?
c) What is the monthly cost?
d) What is the yearly cost?
e) What is the cost over a 4 year period (assuming you purchase each week of the year)?

2. Suppose you fill your gas tank an average of 2.5 times a week over the year. Suppose that the average cost to fill your tank is $47.50 over the same year.
a) What is your estimated weekly gas cost?
b) What is the estimated monthly gas cost?
c) What is the estimated yearly gas cost?
d) What is the estimated cost over a 5 year period (assuming you purchase each week of the year)?
e) What is the problem with calculating long term estimations as we did in part d?

3. Use the balance sheet equation to solve for the unknown value.
a) Suppose you have $21,800 in assets and $2,250 in Liabilities. What is your net worth?
b) Suppose your net worth is $2,186,800 and have liabilities of $488,950. What are your assets?
c) Suppose your net worth is $1,275 and have assets of $1870. What are your liabilities?

4. Create a personal Financial Statement using the example in your PowerPoint presentation for 3C Planning and Budgeting. Be sure to calculate your Net Worth.
Suppose you have $1486.25 in your checking and $2389.22 in savings account. You have stocks totaling $12,500. In addition you have personal property totaling $3400 and other assets of $1200. Your liabilities are $640 to your credit card, $1400 in taxes and $1800 in other liabilities.

5. Create a Personal Cash Flow Statement for the following information. Use the example in your PowerPoint presentation for 3C Planning and Budgeting. Be sure to calculate your Net Cash Flow.
You income from a part-time job is $1400 each month and earn $300 a month from a college fund. If your monthly expenses are $400 for rent, utilities are $45, phone is$50, an average of $250 for groceries and $500 for other.
6. Calculate your opportunity cost for 1 additional year of college according to the figure on slide 17 in PowerPoint presentation for Ch 3 Planning and Budgeting.

7. Suppose you could save $1200 a year for the next 42 years of work. If you could invest this in a retirement account earning 6.4% interest, how much would you have in 42 years when you retire?

8. Suppose you could save $250 a month for the next 45 years. If you could invest this in a retirement account earning 7.2% interest
a) How much would you have in 45 years when you retire?
b) How much interest did you earn?

9. Suppose you want to retire in 40 years to a retirement fund sufficient enough to pay you $150,000 in interest each year forever.
a) What balance would you need in the account to earn $150,000 in interest if APR is 9%?
b) How much would your monthly payments be to earn the amount in part a if you have 40 years to save?
c) How much interest did you earn over the 40 years?

10. Suppose you want to retire to a retirement fund sufficient enough to pay you $150,000 in interest each year forever.
a) What balance would you need in the account to earn $150,000 in interest if APR is 6.8%
b) How much would your monthly payments be to acquire the result from (a) if you plan to contribute into the account for the next 40 years?

11. Suppose your total income was $41000 last year. Your expenditures were as follows:
$18000 in rent and food, $1500 for interest on credit cards and loans, $5400 for car expenses, $11800 for miscellaneous expenses, and $5800 in taxes.
a) What are your total expenses?
b) Will you have a deficit or surplus?
c) What is your debt or surplus

Verified Expert

This task deals with the ascertainment of the overall cost of the expenses incurred on a daily,weekly, monthly and yearly basis. It also involves the in-depth understanding of the components of balance sheet viz. assets, liabilities and net worth. Even the ascertainment of the deficit or surplus has been dealt out. The retirement planning problem has been dealt out in the later section which has done by using excel function. In this way, the assignment deals with the practical section.

Reference no: EM13971544

Questions Cloud

Software review : Research instructional software programs and list two programs you think would be beneficial for your classroom/school and explain how they would benefit your classroom/school. Remember to search for open-source software as well as software that can ..
Convert the standard return into a log return : Suppose that, over a 125 day period, Mike Inc.'s stock price experienced (positive) Standard Returns of 12%. a.) Convert the Standard Return into a Log Return.
Evaluate models of behavior using the basic model : Evaluate models of behavior using the basic model of health promotion and disease prevention, explain in your own words the systemic process that contributes to your client's healthy or unhealthy habits. Evaluate the mind-body connection between y..
Prepare a production budget for january and february : Fuqua Company's sales budget projects unit sales of part 198Z of 10,000 units in January. Prepare a production budget for January and February 2017. Prepare a direct materials budget for January 2017.
Create a personal balance sheet for your assets : Create a personal balance sheet for your assets, liabilities, and net wort - create a personal cash flow statement with your total income, expenses and your net cash flow.
Prepare cash budget for first quarter for deitz corporation : Deitz Corporation is projecting a cash balance of $30,000 in its December 31, 2016, balance sheet. Prepare a cash budget for the first quarter.
Briefly explain the difference between adjusting entries and : On March 31, 2010, the following data were accumulated to assist the accountant in preparing the adjusting entries for Hackney Realty. Journalize the adjusting entries required at March 31, 2010. Briefly explain the difference between adjusting entri..
Prepare budgeted multiple-step income statements : Prepare budgeted multiple-step income statements for each month in columnar form. Show in the statements the details of cost of goods sold.
Develop programs in the administration of health care : Develop logic model to develop programs in the administration of health care. Health Care Administration: Demonstrate an understanding of the forces impacting health delivery systems and the effective management of health care administration

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd