For the balance sheet, fill in the assets and liabilities based on the facts given in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For the balance sheet, fill in the assets and liabilities based on the facts given in the assignment. Only fill in the grey boxes. The formulas should add up all of the assets and liabilities. Create a formula to calculate net worth. As of August, 2022 (Month, Year) Checking Account Savings Account Cash (tax refund + cash) Other (cash for rent/utilites) Assets Current Assets Total Current Assets Investment Assets Roth IRA Employer 401k Total Investment Assets TV Furniture Car Condo Ipad Graduation Ring Personal Assets 40 5 Total Assets Total Personal Assets SSSSSSS $ 2,050 $ 1,085 SSSSSS $ 3,835 $ 250 $ 1,250 $ 5,000 $ SSSSSS 450 $ 6,250 SSSSS $ 2,200 $ 15,000 $ 60,000 500 250 820 $ $ 78,770 $ 88,855 Liabilities Short-Term Liabilities $ Credit card Medical (Dentist) Funiture Loan Mortgage Student Loans Car Loan SSSSS Net Worth $ Total Short Term Liabilities $ 1,850 Long-Term Liabilities 800 400 650 $ 45,000 $ 23,000 $ 8,500 S SS Total Long Term Liabilities $ 76,500 Total Liability $ 78,350 $ 10,505 SER Use the following to create a balance sheet in the attached Google Sheet template. . You have $250 in your checking account. . You have $2,050 in your savings account. . You purchased an iPad last summer and it is valued at $500. You bought a graduation ring and it is valued at $250. You purchased new furniture for your apartment. It is valued at $2,200 but you still owe $650. Your car is valued at $15,000 but you still owe $8,500. . You owe $800 on a credit card. . . . You just opened a Roth IRA and have put $1,250. You participate in your employer's 401k program. You have saved $5,000 so far. You needed a root canal procedure at your dentist office. You owe $400. • You just cashed your income tax refund check of $1,000. . . You purchased a new TV that is valued at $820. . You have $85 in cash. . You have a student loan balance of $23,000. . You purchase a condo for $60,000 and you owe $45,000 on the mortgage. You and your best friend move into your new condo. They just paid you $450 cash for monthly rent and utilities. . For the balance sheet, fill in the assets and liabilities based on the facts given in the assignment. Only fill in the grey boxes. The formulas should add up all of the assets and liabilities. Create a formula to calculate net worth. As of August, 2022 (Month, Year) Checking Account Savings Account Cash (tax refund + cash) Other (cash for rent/utilites) Assets Current Assets Total Current Assets Investment Assets Roth IRA Employer 401k Total Investment Assets TV Furniture Car Condo Ipad Graduation Ring Personal Assets 40 5 Total Assets Total Personal Assets SSSSSSS $ 2,050 $ 1,085 SSSSSS $ 3,835 $ 250 $ 1,250 $ 5,000 $ SSSSSS 450 $ 6,250 SSSSS $ 2,200 $ 15,000 $ 60,000 500 250 820 $ $ 78,770 $ 88,855 Liabilities Short-Term Liabilities $ Credit card Medical (Dentist) Funiture Loan Mortgage Student Loans Car Loan SSSSS Net Worth $ Total Short Term Liabilities $ 1,850 Long-Term Liabilities 800 400 650 $ 45,000 $ 23,000 $ 8,500 S SS Total Long Term Liabilities $ 76,500 Total Liability $ 78,350 $ 10,505 SER Use the following to create a balance sheet in the attached Google Sheet template. . You have $250 in your checking account. . You have $2,050 in your savings account. . You purchased an iPad last summer and it is valued at $500. You bought a graduation ring and it is valued at $250. You purchased new furniture for your apartment. It is valued at $2,200 but you still owe $650. Your car is valued at $15,000 but you still owe $8,500. . You owe $800 on a credit card. . . . You just opened a Roth IRA and have put $1,250. You participate in your employer's 401k program. You have saved $5,000 so far. You needed a root canal procedure at your dentist office. You owe $400. • You just cashed your income tax refund check of $1,000. . . You purchased a new TV that is valued at $820. . You have $85 in cash. . You have a student loan balance of $23,000. . You purchase a condo for $60,000 and you owe $45,000 on the mortgage. You and your best friend move into your new condo. They just paid you $450 cash for monthly rent and utilities. .
Expert Answer:
Related Book For
Investment Analysis and Portfolio Management
ISBN: 978-0538482387
10th Edition
Authors: Frank K. Reilly, Keith C. Brown
Posted Date:
Students also viewed these accounting questions
-
Account form presentation for the balance sheet is demonstrated by what? Question options: a) Assets=liabilities and equity in horizontal format b) The liabilities are deducted from assets and then...
-
In Cell H4, enter a formula to calculate the projected secondquarter. Enter a formula to multiply the first quarter value by 1plus the projected increase. $0 April May June (1Q) Total Avg 1Q (H4)...
-
Multiple Choice Questions 1. Another name for the balance sheet is the a. Statement of financial position b. Statement of operations. c. Statement of profit and loss. d. Statement of earnings. 2....
-
Use the Chain Rule to evaluate the partial derivative at the point specified. /u and /v at (u, v) = (1,1), where f(x, y, z) = x + yz, x = u + v, y = u + v, z , Z = uv
-
Glenns Electronics, a small company, has set up a computer service. The table that follows shows the revenue expected for the first five months of operation, in addition to the costs for office...
-
Reconsider part (c) of Problem 6-1. Use the regression model to generate response surface and contour plots of the tool life response. Interpret these plots. Do they provide insight regarding the...
-
What does the product moment correlation determine?
-
Cash Equation Details Corp has a book net worth of $8,500. Long-term debt is $1,800. Net working capital, other than cash, is $2,380. Fixed assets are $6,400. How much cash does the company have? If...
-
Hyrdo Billboard Company entered into an angreement to display billboard advertising for Adele Incorporated for 1 0 months for a $ 6 4 , 0 0 0 fixe fee. The agreement also includes a potential $ 6 , 5...
-
Its Just Lunch is a nationwide service company that arranges lunch dates for clients. Its Just Lunch collects cash up front for a package of dates. Suppose your group is opening an Its Just Lunch...
-
The estimated monthly Canada demand function for bananas is Q = 120 - 50p + 64pa where p is the price of bananas and pa is the price of apples, a substitute for bananas. The supply function for...
-
Mane Street normally sells 3000 economy-size bottles of shampoo for \(\$ 10\) per bottle. The cost to manufacture the shampoo is \(\$ 5.00\) per bottle. Further variable processing costs of \(\$...
-
The local council has been approached to set up a new industrial precinct of the edge of a suburb. A number of proposals have been put forward for the use of the land and the community has been...
-
A manufacturing business that makes photocopiers has annual net sales of \(\$ 30\) million from selling 60000 photocopiers per year. As a part of its manufacturing process, it consumes 150000...
-
The Possum Transport Company produces bikes, skates and mopeds. Mopeds are not as popular as they used to be, and the company is considering dropping this product. Possum currently sells 10000 mopeds...
-
An electronics manufacturing business is designing a new range of digital radios. The business is environmentally aware and has found a way to recycle old analogue radios as well as their new digital...
-
Products in an automotive store consist of the following: 100 car floor mats delivered on January 10 at a cost of $20 each and 150 car floor mats delivered on February 2 at a cost of $22 each. They...
-
Refer to the table to answer the following questions. Year Nominal GDP (in billions) Total Federal Spending (in billions) Real GDP (in billions) Real Federal Spending (in billions) 2000 9,817 578...
-
Describe how you would compute the abnormal rate of return for a stock for a period surrounding an economic event. Give a brief example for a stock with a beta of 1.40.
-
You can acquire convertible bonds from a rapidly growing company or from a utility. Speculate on which convertible bond would have the lower yield and discuss the reason for this difference.
-
Assume that you and a business associate develop an efficient frontier for a set of investments. Why might the two of you select different portfolios on the frontier?
-
The overall process of creating a capital budget proposal has a lot of similarities to writing a business plan for a start-up company. Describe three aspects of the similarities between a budget...
-
There are three general categories of capital budget scenarios: replacement, expansion, and investment in a NewCo. Describe the overall decision-making context for each. How do they draw on similar...
-
In analysis, some focus seems to be on the need for NPV equations to be applied to projects that are mutually exclusive. But in practice we find that the lines are blurred in capital budgeting....
Study smarter with the SolutionInn App