Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi , please help me understand and solve these financial and ratios 3 questions part with steps. I have provided the income and expenses sheet

Hi, please help me understand and solve these financial and ratios 3 questions part with steps. I have provided the income and expenses sheet about the questions. Thanks I appreciate it. PFI 2301: Personal Financial Literacy
information Shert
Project Overviews Throughout the semester, you will be working or an application based sternario on how to apply the course learning goals. All projects will be submitted through Excel. The "trifo Sheet" (where you're now) will be the landing page for all of the infornation to complete each Learning Goal Project. Make sure to keep up with the schectule for the due dates and review the nubrics to make sure you know how ench Priect will be graded. Let's get started!
Unit 1: BASICS - The Tools and the Rules of Personal Finance
LG3-Understand how financial statements & ratios and basic tax fundamentals impoct the financial planning process.
Income and Expenses are given in annual amaounts
Jessica Age
34
Salary $ 60,000,00
Mortgage Payments $ 22,000.00
Money Market Account $ 15,000.00
Mutual Fund Account $ 1,000.00
Home Value $160,000.00
Furnature Value $ 2,300.00
Mortgage Balance $138,000.00
Roth IRA $ 8,500.00
Credit Card Payments $ 600.00
Entertainment $ 1,200.00
Checking Account $ 22,000.00
Car Payments $ $,100.00
Consulting Income $ 2,000.00
Car Loan Balance $ 4,000.00
Graceries $2,400.00
Fuel $1,000.00
Car Value $8,000.00
Employer Plan $10,000.00
Student Loan Payment $6,000.00
Stamp Collection $500.00
Credit Card Balance $1,000.00
Amazon Purchases $2,500.00
Savings Account $5,000.00
Past Due Speeding Tichet $350.00
Student Lan Bolance $20,000.00
Insurance Payments $3,000.00 Utilities
$2,300.00
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Analysis With Microsoft Excel 2016

Authors: Timothy R. Mayes, Todd M. Shank

8th Edition

1337298042, 9781337298049

More Books

Students also viewed these Finance questions

Question

Is your management system defined?

Answered: 1 week ago

Question

Do you have a comprehensive communication plan for your strategy?

Answered: 1 week ago

Question

Do you have sufficiently ambitious milestones?

Answered: 1 week ago