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

  What is the divisions margin what is the divisions turnover

glass wares is a division of a major corporation. the following data are for the latest year of

  How many payments is that if money earns 612 how much cash

bobs granddaughter was born today. bob wants to be able to give his granddaughter 200 a month from her 18th birthday

  Linearity in a set of data

In regression forecasting, what do we mean when we say that there is linearity in a set of data? As a healthcare manager, why is it important for you to test for linearity of data, and how would you go about this task?

  The authorized share capital of the alfred cake company is

the authorized share capital of the alfred cake company is 100000 shares. the equity is currently shown in the companys

  Please use the project from assignment 1 to complete this

please use the project from assignment 1 to complete this assignment which requires that you provide the necessary

  Find the company float

A company receives an average of $11,000 in checks each day. The delay in clearing is typically 4-days. The current interest rate is .016% per day.

  Should the bank buy or sell futures

1If a bank will invest $300,000,000 in treasury bonds (par=price) in 3-months. the duration on the bonds is 12.5 year. a,should the bank buy or sell futures?

  Historically high return stocks have exhibited lower risk

historically high return stocks have exhibited lower risk than low return stocks?.just the opposite what the sml

  Objectives questions on key data

Determine which of the following are temporary differences that are normally classified as expenses or losses that are deductible after they are recognized in financial income?

  Number of days outstanding for accounts

Selected recent balance sheet and income statement information for The Gap, Inc. follows:

  A survey was conducted in indiana kentucky and ohio to

a survey was conducted in indiana kentucky and ohio to determine the attitude of voters concerning school busing. a

  Describe pros and cons of each approach relate the

you are an investment advisor and your client is not sure whether to invest in actively or passively managed fund.

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