11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Home H12 A Excel File Edit View Insert Insert B AutoSave OFF Cash Inflows Cash Outflows x Other Other Draw Page Layout D For month ending Salary (take-home) Other income: Other income: Total Income fx Set Up Your Variance Feb - Jan Fixed Expenses Mortgage or rent Loan payments Insurance Total fixed outflows Variable Expenses Food Clothing Electricity Telephone Water I Transportation Personal care Medical expenses Recreation/entertainment Gifts Donations Other Other Total variable outflows Total Outflows Surplus/Deficit E F Data Jan-23 72 use the rows below for your calculation 73 $0.00 $0.00 $0.00 $0.00 $0.00 63 64 Use the data below for your calculations: 65 * 10 percent down payment 66 33 percent for TIPI 67 *450 for credit card debt 68 *375 for personal laon 69 * 6 perscent interest ratye on a 30 year mortgage 70 71 G Data Formulas Feb-23 $0.00 $0.00 $0.00 Format Tools Data Window Help $0.00 $0.00 H Set Up Your Variance Feb - Jan $0.00 $0.00 $0.00 $0.00 Your Financial Workbook - HW Assignment 3 - Bud Review Tell me Data Data Mar-23 $0.00 $0.00 $0.00 $0.00 $0.00 J Set Up Your Variance Feb -- March $0.00 $0.00 $0.00 $0.00 $0.00 K View L Set Up Your Budget Monthly Budget 52 53 54 55 56 What's Next for Your Personal Financial Plan? 58 1) Calculate your variances (February and january) 59 2) Calculate your variances from (march to February) 60 3. Calculte your monthly budget based on 3 months of data collected. 61 4) You are estimating you will be putting$ 10 percent to cover down payment from your saving account 62 Calculate your affordable mortgage amount h-that would be suggested by a lending institution based on your estimated income of 56,000 per year. M Automate N O P R 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Home H12 A Excel File Edit View Insert Insert B AutoSave OFF Cash Inflows Cash Outflows x Other Other Draw Page Layout D For month ending Salary (take-home) Other income: Other income: Total Income fx Set Up Your Variance Feb - Jan Fixed Expenses Mortgage or rent Loan payments Insurance Total fixed outflows Variable Expenses Food Clothing Electricity Telephone Water I Transportation Personal care Medical expenses Recreation/entertainment Gifts Donations Other Other Total variable outflows Total Outflows Surplus/Deficit E F Data Jan-23 72 use the rows below for your calculation 73 $0.00 $0.00 $0.00 $0.00 $0.00 63 64 Use the data below for your calculations: 65 * 10 percent down payment 66 33 percent for TIPI 67 *450 for credit card debt 68 *375 for personal laon 69 * 6 perscent interest ratye on a 30 year mortgage 70 71 G Data Formulas Feb-23 $0.00 $0.00 $0.00 Format Tools Data Window Help $0.00 $0.00 H Set Up Your Variance Feb - Jan $0.00 $0.00 $0.00 $0.00 Your Financial Workbook - HW Assignment 3 - Bud Review Tell me Data Data Mar-23 $0.00 $0.00 $0.00 $0.00 $0.00 J Set Up Your Variance Feb -- March $0.00 $0.00 $0.00 $0.00 $0.00 K View L Set Up Your Budget Monthly Budget 52 53 54 55 56 What's Next for Your Personal Financial Plan? 58 1) Calculate your variances (February and january) 59 2) Calculate your variances from (march to February) 60 3. Calculte your monthly budget based on 3 months of data collected. 61 4) You are estimating you will be putting$ 10 percent to cover down payment from your saving account 62 Calculate your affordable mortgage amount h-that would be suggested by a lending institution based on your estimated income of 56,000 per year. M Automate N O P R
Expert Answer:
Answer rating: 100% (QA)
To solve this problem we will follow this steps 1 Calculate the variances between February and Janua... View the full answer
Related Book For
Introduction to Java Programming, Comprehensive Version
ISBN: 978-0133761313
10th Edition
Authors: Y. Daniel Liang
Posted Date:
Students also viewed these finance questions
-
An oil and gas exploration firm invested $1,700,000 in drilling for natural gas in a new gas field. The firm's geologist believes the field has the potential to produce gas for 25 years. The revenue...
-
Rewrite Listing 30.1 to display the output in a text area, as shown in Figure 30.30. Listing a 1b2b3b 4b 5 b6bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb 7 8bbbbbbbbbbbbbbbbbbbb 9bb10 16 11 12 13 14...
-
If I have a lump sum of $28,621 today, calculate the value of that lump sum 29 years in the future assuming earn 2.50% compounded annually on my investment?
-
1. An exponential growth model has the form ________, and an exponential decay model has the form ________. 2. A logarithmic model has the form ________ or ________. 3. In probability and statistics,...
-
Outdoors Unlimited operates a fishing lodge in northern Canada. The following cost information has been developed by the companys accountant: Fixed costs: Salaries . . . . . . . . . . . . . . . . . ....
-
A long wire that is at rest in the Farth reference frame initially carries no current. Observer \(\mathrm{E}\) in this reference frame measures linear charge densities of \(\lambda_{\mathrm{En}}=\)...
-
In a Q system, the demand rate for strawberry ice cream is normally distributed, with an average of 300 pints per week. The lead time is 9 weeks. The standard deviation of weekly demand is 15 pints....
-
* Installing integrated software needs more memory than installing many .standalone applications True O False
-
Our gender is a huge aspect of our identity. From birth, we typically are identified as a boy or a girl and quickly learn about what it means to be male or female in our family, school, community,...
-
The essay should include two parts. In the first part you need to focus on the following topics: (1) The role of project planning, (2) Advantages of project planning and (3) Possible disadvantages of...
-
Case: "The long time employee" 1. Which alternative appears sufficiently workable to be the first one attempted? And what information do you need to assemble in preparing to justify your decision? 2....
-
Describe a scenario where you demonstrated adept conflict resolution skills, utilizing advanced communication strategies to navigate contentious discussions and achieve mutually beneficial outcomes.
-
How do you integrate advanced communication and active listening skills to ensure clarity, understanding, and alignment among conflicting parties during negotiation and mediation processes?
-
what is your opinion about the relationship between competitive strategy and supply chain to the fit strategy to achieve company success?
-
I need information about a micro start up business idea to sell online cooperate hampers. Customers subscribe to our company to order the special hampers due to the harsher lockdowns in Australia....
-
Answer the following two independent questions. a. MM Corporation is considering several proposed investments for the coming budget year. MM produces electrical apparatus for industrial complexes....
-
Write a program that reads three edges for a triangle and computes the perimeter if the input is valid. Otherwise, display that the input is invalid. The input is valid if the sum of every pair of...
-
Write a method that returns the intersecting point of two lines. The intersecting point of the two lines can be found by using the formula shown in Programming Exercise 3.25. Assume that (x1, y1) and...
-
Design a class named MyInteger. The class contains: An int data field named value that stores the int value represented by this object. A constructor that creates a MyInteger object for the...
-
(a) The longitudinal data set "v4c" is in the vertical format; transform it into the horizontal format. (b) Transform the data set you obtained in part (a) back into the vertical format.
-
Plot the mean/SD of HIV knowledge of adolescent girls at baseline and three months post treatment stratified by treatment for the Sexual Health study.
-
Prove (9.31) . = BE (GS;S; G) BT, B = (B), B-T (9.31)
Study smarter with the SolutionInn App