Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need this assignment today before midnight tonight. Case Study: Carol Jones Carol works as a business representative for an import/export company. Her job provides
I need this assignment today before midnight tonight.
Case Study: Carol Jones Carol works as a business representative for an import/export company. Her job provides her with the opportunity to travel and experience new things. Because she travels so much, Carol feels that she does not have a handle on her finances. She has decided to pay a visit to a financial advisor for help. All items are monthly unless otherwise indicated: Carol's Salary $2,000 Auto Loan Payment New Home Cost $100,000 Mastercard Balance Gas/Heating $100 Visa Card Balance Electric $125 Bloomingdale Card Balance Water $60 Personal Loan Balance Internet/Cable $150 Mortgage Balance Home Phone $50 Mortgage Payment Cell Phone $200 New Car Cost Food $250 Gym Membership Mortgage Payment $796 Personal Loan Payment Car Insurance $165 Carol's 401K Balance Savings Balance $500 Auto Loan Balance Checking Balance $1,000 Visa Payment Lawn Service $100 Bloomingdale Payment Mastercard Payment $262 $5,000 $3,000 $1,500 $5,000 $95,000 $796 $20,000 $20 $94 $50,000 $15,000 $60 $30 $100 Int 15% Int 15% Int 29% Int 5%, 60 mos Assignment Requirements: Microsoft Excel spreadsheet with Three (3) Sheets: Create the following financial analyses using the information provided for Carol (Hint: first identify each item as an Asset, Liability, Cash Inflow or Cash Outflow): Sheet 1. a Balance Sheet, including a line item showing Carol's overall Net Worth. Sheet 2. a Cash Flow Statement, for a single month, including a line item showing Carol's overall Net Cash Flow. Organize cash outflows by Debt payments and Expenses, with subtotals for each. Format these 2 sheets professionally and consistently. APA formatting is NOT required. Sheet 3. Write a concise (1 paragraph each) response that addresses each the following items: 1. Apply financial planning concepts to advise Carol and explain how Carol can benefit from financial planning. Describe the benefits of using financial statements in financial planning. 2. Explain strategies that Carol can use to increase her net worth. How does this affect her cash flow? 3. Describe the sources available for asset management. 4. Compile a list of legal protections that can be used to protect Carol's assets. Format this sheet to be sure each response is fully legible in the cells in which typed (use wrap text if it runs off the screen). Use a separate cell(s) with section header for each of the above requirements. APA formatting is NOT required. Click the Assignment Files tab to submit your Microsoft Excel spreadsheet. Submit only 1 file for your assignmentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started