Question: Interest and Assumptions C= John; Projected Cash Flow Statement begin{tabular}{|l|lc|} hline Projected Cash Flow Statement as of: & January 1, 2022 hline Prepared for

$Interest and Assumptions C= John; Projected Cash Flow Statement \begin{tabular}{|l|lc|} \hline$ $Projected Cash Flow Statement as of: & January 1, 2022 \\ \hline$ $Prepared for the exclusive use of: & John \& Rebecca \\ \hline$ $Cash Inflow and Outflow & \multicolumn{2}{c|}{ Amount } \\ \hline Cash Inflow$

Interest and Assumptions C= John; Projected Cash Flow Statement \begin{tabular}{|l|lc|} \hline Projected Cash Flow Statement as of: & January 1, 2022 \\ \hline Prepared for the exclusive use of: & John \& Rebecca \\ \hline Cash Inflow and Outflow & \multicolumn{2}{c|}{ Amount } \\ \hline Cash Inflow & $ & 224,000.00 \\ \hline John's Salary & $ & 135,000.00 \\ \hline Rebecca's Salary & $ & 72,000.00 \\ \hline Etsy Shop & $ & 17,000.00 \\ \hline Cash Outflows & $ & 198,279.80 \\ \hline Income Tax & $ & 61,000.00 \\ \hline Boat Loan and Slip Fee & $ & 19,171.51 \\ \hline Mortgage & $ & 42,108.29 \\ \hline School Fees & $ & 20,000.00 \\ \hline HOA Fees & $ & 6,000.00 \\ \hline Life Style Expenses & $ & 30,000.00 \\ \hline Basic Necessities & $ & 20,000.00 \\ \hline Surplus/Deficit & & $25,720.20 \\ \hline \end{tabular} Ratio Analysis - What is the Emergency Fund Ratio? Is it adequate? - What is the Current Ratio? Is it adequate? - What is the Housing Ratio 1? Is it adequate? - What is the Housing Ratio 2? Is it adequate? - What is the Debt-to-Total Assets? Is it adequate? - What is the Net Worth-to-Total Assets? Is it adequate? - What is the Surplus or Deficit? - What is the Investment Asset-to-Gross Pay? - What is the client's highest interest debt? Do you think they should focus on paying it down or savings more? Interest and Assumptions C= John; Projected Cash Flow Statement \begin{tabular}{|l|lc|} \hline Projected Cash Flow Statement as of: & January 1, 2022 \\ \hline Prepared for the exclusive use of: & John \& Rebecca \\ \hline Cash Inflow and Outflow & \multicolumn{2}{c|}{ Amount } \\ \hline Cash Inflow & $ & 224,000.00 \\ \hline John's Salary & $ & 135,000.00 \\ \hline Rebecca's Salary & $ & 72,000.00 \\ \hline Etsy Shop & $ & 17,000.00 \\ \hline Cash Outflows & $ & 198,279.80 \\ \hline Income Tax & $ & 61,000.00 \\ \hline Boat Loan and Slip Fee & $ & 19,171.51 \\ \hline Mortgage & $ & 42,108.29 \\ \hline School Fees & $ & 20,000.00 \\ \hline HOA Fees & $ & 6,000.00 \\ \hline Life Style Expenses & $ & 30,000.00 \\ \hline Basic Necessities & $ & 20,000.00 \\ \hline Surplus/Deficit & & $25,720.20 \\ \hline \end{tabular} Ratio Analysis - What is the Emergency Fund Ratio? Is it adequate? - What is the Current Ratio? Is it adequate? - What is the Housing Ratio 1? Is it adequate? - What is the Housing Ratio 2? Is it adequate? - What is the Debt-to-Total Assets? Is it adequate? - What is the Net Worth-to-Total Assets? Is it adequate? - What is the Surplus or Deficit? - What is the Investment Asset-to-Gross Pay? - What is the client's highest interest debt? Do you think they should focus on paying it down or savings more

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following table shows the fastest-growing occupations that require a bachelors degree, based on the estimated employment in 2024 and the predicted percent increase in employment from 2014 to...

C= John; Projected Cash Flow Statement \begin{tabular}{|l|lc|} \hline Projected Cash Flow Statement as of: & January 1, 2022 \\ \hline Prepared for the exclusive use of: & John \& Rebecca \\ \hline...

At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in the next five years....

VII. Report for CEO At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in...

you didint make the second income sheet with the information at the bottom and also didint make the projected cash flow with those same numbers for the year On January 1 , 2 0 1 9 , Jean Higgins...

On January 1 , 2 0 1 9 , Jean Higgins organized a new consulting firm called The Higgins Group. On December 3 1 , 2 0 1 9 , the company's records showed the following items. First, indicate the...

Required: a) Calculate the current ratio, quick ratio, gross profit margin, profit margin, and debt to total assets for both years. Explain whether the ratios are improving or declining. b) Review...

Required: Refer to the statements and notes and answer the following questions. a) What type of income statement format does the company use (single, multiple step, condensed)? Explain clearly why...

Balances the following redox reactions: a) Put the oxidation numbers of each element. b) Write the half-reactions and indicate in each case which one oxidizes and which one reduces. CrCl3 + MnO2 +...

Buenolorl Company produces a well-known cologne. The standard manufacturing cost of the cologne is described by the following standard cost sheet: Management has decided to investigate only those...

To make things worse, Mary was almost finished with the most recent annual report, and it appeared that earnings were down for the first time ever. Her preliminary calculations showed earnings per...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Spotlight Rsums is a complete rsum-writing service that assists in preparing rsums, applications to graduate schools, and cover letters. Scott Regis, the owner of Spotlight Rsums, has hired you to...

Write a letter asking them to refund your $1,500 down payment.

Technology. You are currently employed by the City of Silver Springs in the accounting department. One of your colleagues, Paul Armstrong, was recently diagnosed with a brain tumor and underwent...