ZuoTi.Pro
Question

Please see question on top of the tables attached.


Gb699 Decision Making Model Enter formulas in the below cells. Afirm reported the financial data for one year. Prepare the balance sheet and income statement Complete the cash flow calculations. Column B Column C Column D ColumnE Row 10 Column A 10 Reported Data Cash Other assets Debt Capital Revenues Expenses Interest Taxes Dividends, percent of income Jan-17Dec-17 10700 37768 521000519000 11000 14000 520700542768 609950 544000 9975 20% 40% 12 13 14 15 12 13 14 15 16 17 18 19 20 21 17 18 19 20 21 Balance sheet Cash Other assets Total assets Debt Capital Liabilities & equity Jan-17 Dec-17 23 24 25 23 24 25 26 27 28 29 30 31 32 27 28 29 30 Income Statement Revenues Expenses

← X Gb699-Fin2 Wrk.xlsx 32 Expenses Operating income Interest Pre-taxearnings Taxes Net income Dividends 34 35 36 37 38 39 40 41 42 43 35 37 38 39 40 41 42 43 Cash Flow Cash low from operations Net income Less dividends Changes in balance sheet accounts Change in other assets Change in debt Expected change in cash 45 46 47 47 49 Check to be sure it is correct Starting cash Ending cash Actual Change in cash 49 50 51 52 53 54 52 53 Present Value Exercise What is the following assets net present value? What is the internal rate of return on the investment? 57 58 59 60 61 62 56 57 58 Year 0 Year 1Year 2 Year 3 59 60 20000 2500030000 61 70000 62 Net Present Value Calculation NCO Annual Cash Residual Cash -100000 20

Open X Gb699_Fin2_Wirk.xlsx 52 53 54 Actual Change in cash 53 Present Value Exercise What is the following assets net present value? What is the internal rate of return on the investment? 56 57 58 59 60 61 56 57 58 Year 0 Year 1Year 2 Year 3 59 60 20000 25000 30000 61 70000 62 12% 63 15% 64 2.68 65 Net Present Value Calculation NCO -100000 Annual Cash Residual Cash Required Rtn Cash Flow Req Rtn, Residual PV Mid-year Factors Present Values PV Residual 63 12% 12% 0.57 1.62 67 68 69 70 67 68 69 70 71 Year 3 72 73 74 75 76 Formula: FIRI·STVYN = PV Internal Rate of Return Calculation Year 0 Year 1Year 2 NCO 74 75 76 Annual Cash Residual Cash Discount Factor to Zero NPV Trial/Error, Try PV Md-year Factors Annual Cash Residual Cash NPV IRR Formula: FV(1+STVN PV 78 268 78 79 0.57 1 62 80 81 82 83 81 82 83

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Income Statement Revenues Expenses Operating Income Interest Pre Tax Earnings Taxes (20%) Net income Dividend (40%) 609950 544000 65950 19975 45975 9195 36780 14712 Balance Sheet Cash Other Assets Total Assets Debt Capital Liabilities & equity 37768 519000 556768 14000 542768 556768 Cash Flow Cash Flow from operations Net Income Less: Dividend Changes in Balance sheet accounts Change in other assets Change in Debt Expected change in cash 36780 -14712 2000 3000 27068 starting cash ending cash actual change in cash 10700 37768 27068

0 0
Add a comment
Know the answer?
Add Answer to:
Please see question on top of the tables attached. Gb699 Decision Making Model Enter formulas in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please see the excel sheet attached. Question is on top of first page. inancial Statement wlth...

    Please see the excel sheet attached. Question is on top of first page. inancial Statement wlth Spreadsheet Worksheet Enter formulas in the below cells. Columns A through E contain a worksheet The data is in columns and rows as shown. The data is followed by a financial model. Using an electronic spreadsheet, fill in the blanks Column A Starting Data Initial investment in an asset Equipment Bank loan interest rate on the loan Starting Supplies Percent of cash paid for...

  • Please fill in the blanks. Net Present Value Calculation Year 0 Year 1 Year 2 Year...

    Please fill in the blanks. Net Present Value Calculation Year 0 Year 1 Year 2 Year 3 NCO -100000 Annual Cash 20000 25000 30000 Residual Cash 70000 Required Rtn Cash Flow 12% 12% 12% Req Rtn, Residual 15% PV Mid-year Factors 0.57 1.62 2.68 Present Values _____ _____ _____ _____ PV Residual _____ NPV _____ Formula: FV/(1+$TV)^N = PV Internal Rate of Return Calculation Year 0 Year 1 Year 2 Year 3 NCO _____ Annual Cash _____ _____ _____ Residual...

  • For determining half-lives of radioactive isotopes, it is important to know what the background radiation is...

    For determining half-lives of radioactive isotopes, it is important to know what the background radiation is in a given detector over a specific period. The following data were taken in a y -ray detection experiment over 98 ten-second intervals: 58 50 57 58 64 63 54 64 59 41 43 56 60 50 46 59 54 60 59 60 67 52 65 63 55 61 68 58 63 36 42 54 58 54 40 60 64 56 61 51 48...

  • NO Excel. Please show all steps. May the ratings be ever in your favor.Thank you. 61,...

    NO Excel. Please show all steps. May the ratings be ever in your favor.Thank you. 61, 52, 59, 57, 56, 56, 58, 55, 56, 60, 57, 58, 53, 57, 56, 55, 57, 61, 58, 59, 56, 59, 57, 54, 54 Mean = 56.84 , Variance = 5.094 , Standard Deviation = 2.257 , Range = 9 , Median = 57 Use this dataset, answer the following questions. Enter the number with at least 3 decimal places. 1. Suppose the upper...

  • Consider the below matrixA, which you can copy and paste directly into Matlab.

    Problem #1: Consider the below matrix A, which you can copy and paste directly into Matlab. The matrix contains 3 columns. The first column consists of Test #1 marks, the second column is Test # 2 marks, and the third column is final exam marks for a large linear algebra course. Each row represents a particular student.A = [36 45 75 81 59 73 77 73 73 65 72 78 65 55 83 73 57 78 84 31 60 83...

  • West Battery Corp. has recently been receiving complaints from retailers that its 9-volt batteries are not...

    West Battery Corp. has recently been receiving complaints from retailers that its 9-volt batteries are not lasting as long as other name brands. James West, head of the TOM program at West's Austin plant, believes there is no problem because his batteries have had an average life of 60 hours, about 10% longer than competitors' models. To raise the time above this level would require a new level of technology not available to West. Nevertheless, he is concerned enough to...

  • Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the stu...

    Problem 4: Variables that may affect Grades The data set contains a random sample of STAT 250 Final Exam Scores out of 80 points. For each individual sampled, the time (in hours per week) that the student spent participating in a GMU club or sport and working for pay outside of GMU was recorded. Values of 0 indicate the students either does not participate in a club or sport or does not work a job for pay. The goal of...

  • Problem 1: Confidence Interval for Percentage of B’s. The data set “STAT 250 Final Exam Scores”...

    Problem 1: Confidence Interval for Percentage of B’s. The data set “STAT 250 Final Exam Scores” contains a random sample of 269 STAT 250 students’ final exam scores (maximum of 80) collected over the past two years. Answer the following questions using this data set. a) What proportion of students in our sample earned B’s on the final exam? A letter grade of B is obtained with a score of between 64 and 71 inclusive. Hint: You can do this...

  • Math Previous 1 Next Question 2 of 4 (1 point) Question The following table presents the...

    Math Previous 1 Next Question 2 of 4 (1 point) Question The following table presents the daily high temperatures for the city of Macon, Georgia, in degrees Farenheit, for the winter months of January and February in a recent year. If there are no leaves, enter "N." Check Answer 67 58 67 56 74 56 58 65 63 77 53 73 57 51 56 48 68 51 66 64 53 78 61 55 69 56 63 61 71 51 66...

  • please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut...

    please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut Ca Copy Format Painter Clipboard D23 Font НА ЛИ UBLIC 1 Homework Assignment 2 Data Sheet Assumptions 2017 2016 650 935 50 25 5 Accounts payables 885 6 Accounts receivables 950 7 Net Sales 7,800 5,500 8 Common stock 350 350 9 Operating costs 5,243 3,756 10 Gross fixed assets 4,500 3,500 11 Interest expense 12 Long-term debt 2,000 1,800 13 Depreciation & amortization...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT