Results 1 to 4 of 4

Calculate according to the values of adjacent boxes

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2009
    Location
    Israel
    MS-Off Ver
    Excel 2003
    Posts
    3

    Calculate according to the values of adjacent boxes

    In the chart I attached there are 20 columns and 7 rows.

    The calculations are as follows:

    K in first period - 8 (given)

    product per worker (y) - 2*K^(1/3) = 4

    Total invesment - s*y - s (savings rate) is given as 0.1 and y was calculated in the previous line. s*y = 0.1*4 = 0.4

    Depreciation on capital - deperciation rate is set at 2.5% (0.0025) so the depreciation is 0.0025*k = 0.0025*8 = 0.2

    Net investment = Total investment (0.4) - Depreciation (0.2) = 0.2

    Consumption per worker = product per worker (4) - Net investment (0.4) = 3.6

    Growtn in product per worker - Can only start calculating from next period. It is (yt-yt-1)/yt-1. (Next year's product per worker minus this year's product per worker, the answer is divided by last year's product per worker).

    How do I make excel do these calculations? Thank you.
    Attached Files Attached Files
    Last edited by nordinho; 11-16-2009 at 05:46 AM. Reason: Changing title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1