Question: U V W E Jun 15 F Jun 16 G Jun 17 Jun 19 N Jun 24 0 Jun 25 Jun 26 4 6 7

U V W E Jun 15 F Jun 16 G Jun 17 Jun 19 N Jun 24 0 Jun 25 Jun 26 4 6 7 11 81 A B 1 The Widget Company Inc (USD

U V W E Jun 15 F Jun 16 G Jun 17 Jun 19 N Jun 24 0 Jun 25 Jun 26 4 6 7 11 81 A B 1 The Widget Company Inc (USD $m) 2 Calculations Cost of sales Total expenses Days payable Accounts payable $m $m days 33,637.50 11,774.80 37.00 4,590.86 H Jun 18 3 37,113.60 14,100.06 37.00 5,191.52 35,332.83 12,895.84 37.00 4,888.93 Jun 20 5 40,165.24 15,241.43 37.00 5,601.22 38,609.28 14,659.60 37.00 ,399.86 KL M Jun 21 Jun 22 Jun 23 8 41,783.90 43,467.7945,219.54 15,846.44 16,475.56 17,129.75 37.00 37.00 37.00 5,841.98 6,076.45 6 ,320.34 83 47,041.89 1 7,810.00 37.00 6,556.07 48,937.67 18,517.37 37.00 6,837.91 Jun 27 12 52,961.53 20,017.82 37.00 7,397.91 50,909.86 19,252.93 37.00 7,112.39 Jun 28 Jun 29 Jun 30 13 14 15 55,095.88 57,316.24 59,626.09 20,813.20 21,640.29 22,500.37 37.00 37.00 37.00 7,673.878,003.818,325.15 84 $m 5 85 0.00 4 3,867.54 (3,867.54) 4,020.11 (152.57) ,166.54 (146.43) 4,335.33 (168.79) 4,498.63 (163.30) 4,693.68 (195.05) 4,883.80 (190.12) 5,081.61 (197.81) 5,272.975,501.555,724.35 (191.36) (228.58) (222.80) 5,956.15 (231.81) 6,180.406 (224.25) ,448.276 (267.87) ,709.36 (261.08) 86 Net Working Capital Net working capital Change in net working capital 89 90 PP&E 91 92 Accounting Depreciation Opening accounting net book value 93 0.00 8,112.00 7,316.25 6,450.04 5,504.78 4,478.07 12,322.87 9,633.336,854.813,984.64 1,020.06 8,339.98 3,447.73 0.00 0.00 94 Sm 0.00 96 One-off capex Regular capex Capital expenditure incurred (nominal) Sm 8,840.00 624.00 9,464.00 0.00 648.96 648.96 0.00 674.92 674.92 0.00 695.17 695.17 0.00 716.02 716.02 10,447.94 737.50 11,185.44 0.00 759.63 759.63 782.42 782.42 0.00 805.89 805.89 0.00 830.06 830.06 12,112.02 8 54.97 12,966.99 0.00 880.62 880.62 0.00 907.03 907.03 0.00 934.24 934.24 0.00 962.27 962.27 97 Sm PP&E - accounting (straight line) years 7.00 Capital expenditure assumed to be made on the first day of the period. Year 99 100 101 102 103 104 105 106 107 108 109 1,352.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,352.00 1,352.00 92.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,541.13 1,352.00 92.71 96.42 99.31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,640.43 1,352.00 92.71 96.42 99.31 102.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 99.31 102.29 1,597.92 0.00 0.00 0.00 0.00 0.00 0.00 0.00 110 111 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,560.94 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 0.00 0.00 0.00 0.00 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 0.00 0.00 0.00 0.00 0.00 3,794.64 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 0.00 0.00 0.00 0.00 5,647.07 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 0.00 0.00 0.00 5,772.87 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1.852.43 125.80 129.58 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 0.00 934.24 1,352.00 92.71 96.42 99.31 102.29 1,597.92 108.52 111.77 115.13 118.58 1,852.43 125.80 129.58 133.46 137.47 962.27 112 113 114 0.00 0.00 0.00 0.00 0.00 0.00 0.00 115 117 118 120 0.00 1,444.71 0.00 3,340.64 0.00 3,676.06 0.00 4,354.76 Accounting depreciation 1,742.72 3,449.16 719 Closing accounting net book value 0.00 8.112.00 7.316.25 6.450.04 5,504.78 4 .478.07 12,322.87 9,633.33 6 ,854.81 3 .984.64 1,020.06 8,339.98 3.447.73 0.00 0.00 0.00 121 Depreciation Rates PP&E - accounting (straight line) PP&E - tax (diminishing value) years % pa 7.00 20.00% Question 5 Analyst comment: "Our accounting specialist thinks our year 15 closing net book value (from an accounting perspective) is understated" [Error(s) in Calculations!91:120] What is the closing accounting net book value ($m) in the Year ending June 2030? a. 6,211.04 b. 6,211.14 6,211.27 d. 6,211.39 e. 6,211.57 f. 6,211.62

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!

Prepare a 2013 gift tax return (Form 709) for Natalie (Social Security number 123-45-6787). Natalie made no taxable gifts in prior years Hint: A correct submission for this assignment will include...

Cryptography and Modular Arithmetic Question What values of m and k make good linear ciphers if the alphabet has 26 characters? Can the person receiving our message decipher it without reconstructing...

Question One You are a secret agent tasked to send and receive information related to national security. As a specialist in cryptography, you have decided to use matrix inverses to provide a simple...

Using the matrix equation E = AM, as well as the key and encoding matrix below, A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 N O P Q R S T U V W X Y Z 14 15 16 17 18 19 20 21 22 23 24 25...

A one-to-one function and its inverse can be used to make information secure. The function is used to encrypt a message, and its inverse is used to decrypt the encrypted message. The following...

Can someone help me with Ai,Aii and b Coding system Each letter is assigned a number based on its position and 27 is used for a blank space. A B C D E F G HJ KL M 1 2 3 4 5 6 7 8 9 10 11 12 13 N O PQ...

This is how matrix encryption works: . You will have a square matrix called the encryption key, called matrix C. The bigger the matrix, the harder your code is to crack. For this project, we will use...

There are no Opening Balances on January 1st The first picture is the transaction The second picture is the first income statement The third picture is the Stmt of retained earnings And Last is the...

Among the departments of J-R Company are a purchasing department, receiving department. accounting department, and finance department. If you were preparing a flowchart of a voucher system to be...

9.3. Prepare a follow-up checklist for each of these situations: A. "K.T. Potential Problem Analysis: Jet-Lagged John" (Chapter 8) B. The example regarding the dead fish in the river (Chapter 3)

Calculate % from January to March only as a % of Total Sales of food and beverage

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Write a proposal using all 18 proposal elements discussed in this chapter.The subject of your proposal can be (a) permitting employees to bring pets to work, (b) instituting job sharing in...

Teamwork. Refer to Application Exercise 2. As directed by your instructor,work with your group to prepare a proposal that responds to an RFP created by another group in your class. (Objectives 1 and...

Technology. Write (or e-mail) three businesses and request copies of their policy on accruing and awarding vacation leave time. Summarize your findings in a memo to your instructor. Describe the...